Here's the number list.
5
203
3450

How do I increase size of font inside of a check box?

I have a worksheet that has unwanted blank rows that came with the export
information. I am trying to delete these rows at one time. I have 1810 lines
to go through and don't want to waste time going through deleting rows. Is
there an easy function to do this?

I am trying to look up from a table -
Column 1        Column 2
H                         1
H                         2

A1                                      B1
     Other translation proteins [ko00000] K03540 [RPR2]
extract ko00000 and K03540 from 2 cells.
Is it possible to achieve that in Excel?

Lets say there is a calendar that has a1 = 1/1/2006 and a2=a1+1, etc.
Now then, lets say you have an array of dates somewhere else and want
to change the background color of a1 if its date appears in the array.
How can I do that?  I have tried if($z$1:$z$10=a1,1,0) and it will ...

I am using Data/Validation/List to display a list based on what i
entered in another cell. using the formula:   INDIRECT({Cel
Reference}).  My problem is one of my needed Named Ranges should be "C
but whenever I try to use it I get an error message.

I need help with data that i have exported from a database.
The date column is in a format i havent seen before
6093   Basically the "6" is for 2006, "093" is 93 days since the first of Jan.
Can someone please help me use the date function to get this into dd/mm/yy

My problem is this
Column A (let's say A2) has a number updated via web query (3-digits, say
901). I have also named all the sheets in the workbook after the possible
numbers that A can show (odd numbers from 901-931). In B2 I have a formula

I'm slightly puzzled.
Can anybody explain me why the following formula works as expected
(returns 320) :
=SUMPRODUCT(INDEX(Sheet2!B2:D6;C6;0);INDEX(sheet3!B2:D6;C6;0))

I have a software called Avaya CMS Supervisor which is used in the BPO
industry to measure employees performance.
I cannot add images to these groups hence I have uploaded it to my
website. Please visit

Can I create a summary worksheet in a workbook that contains totals from each
worksheet in that workbook.

scanned part and entered part of contact list alpha in Excel 2002. Need to
sort by state which is separate column.  Keep getting error message: merged
cells must be same size.  Can't see any difference.  How to find out what
cells are different?  Or is there a different way to ...

I want to be able to remove spaces from a string, that may have
muiltiple words to create a string with no spaces.
For example "sin city" to become "sincity"
The strings will be of a random length and may contain more than 2

This is probably really easy but I can't get it to work. Please help!!!
Below is a sample of the spreadsheet...
I only want the variance to appear when there is something in the
actual field.