Search:

See the attached file with formula

Have you verified that it does not have phrases that initiate with signs?
" =, +, - " " =text… " , " - text" , " +text"

Hello AndyAndy:

When you have a frozen sheet and you press Ctl + Home, the active cell always will be the first cell (angle left superior) of the area that is not frozen.

Is there a way to put a watermark in Excel 2003? I want to put the word draft across the sheet in a watermark.

See the attached file

...i CANNOT PLACE ANOTHER RADIO BUTTON ON THE PAGE WITHOUT THE LAST SET OF OPTION BUTTONS STOP WORKING.

The size of frame is important, the buttons must be INSIDE of it, then you must make frame...

Hi:
When you use a radio button, the value begins with 1 (one) and with each button within a frame the value is increased (2, 3, 4, etc), then, you cannot begin with 0 (zero), but, you can put the...

Another way without using code:

Advantage: You do not need any code
Disadvantage: You need to make this column by column.

1. Select the range (only one column) by example: [I2:I101]
2. Menu...

If you have a yahoo mail, when you make an unload of several files simultaneously, yahoo turn all of them to Zip format.
but if you make an unload one by one, yahoo will respect the original format....

Hello VegasNath:
You can try with "Screen precision" inside to options...

Hi Diego:

You can modify this characteristic within the options of excel, this will affect all the books that you have, but only in Excel and not Access or any other program.
I am going to write...

????
may be with...
"View" menu, "Normal" icon

What about this?

I think It's not possible, when you select a range the movement way is with the key TAB or ENTER.

Tanks Hans

No problem, I'll wait for another

How can I obtain the 5 highest unique numbers in a range of data?

The data are in A1: C6, the awaited results are in Column E
<table border=1><td></td><td align=center>A</td><td...

Or
=INDEX(E2:E7,MATCH("Adult"&"?"&"Art",B2:B7&"|"&D2:D7,0))
=INDEX(E2:E7,MATCH(H1&"?"&H2,B2:B7&"?"&D2:D7,0))
(confirm with Ctrl+Shift+Enter)

you need to changes the format of the cell (Ctrl+1) where is the total:

<font color=red> [h]:mm </font color=red>

Hi Brad:
What you want?, this function ignore of all the cells in target

Try this:

c= "a2:a"
delete the apostrophe, before the sequence
and
e = c & a & d & b

Hi steve:

Look the attach file.

[A3]=DATE($A$2,1,1)
[C3]=IF(MONTH(DATE(($A$2,MONTH($A3),C$2))=ROW()/3,DATE($A$2,MONTH($A3),C$2),"")
Copy and paste in all days
[A6]=DATE($A$2,MONTH(A3)+1,1)
Copy and paste in all months (Col A)
...

and with totals by group <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

I think that you made a copy of the original book that contains the macro. You created a button in a sheet that activates a macro, then you possibly copied the sheet and also the macro, but the...

Hi Tony:


The advantage for Louise to know function DATEDIF, is that also it can use it to obtain years and months

=DATEDIF(A1,B1,