I need to find a value based on a lookup across the top of my spreadsheet and
then a value down the side and where the row and column intersect is the
value I want.

I am trying to get a formula which would put in the top cell what line the
first time a number =>than a number that I want it to look for.
Example
A              B              C

My formulas:
in cell B1 = SMALL($A$1:$A:$10,1)
in cell B2 and down =TRUNC(SMALL(IF($A$1:$A$10>B1,$A$1:$A
$10+0.001*ROW($A$1:$A$10)),1))

Random data set below for example. Using 1 column and many rows:
   A
1) 40
2) 32

I have a woorkbook and I like to put the names of one of the sheets into a
cell on one of the other sheets.
EX
Iin sheet 1 cell A1 I like to have the name of the 3th sheet in the workbook

I have 13 categories and each of them has approx ten subcategories.
When you select the category in column A from a drop down validation list I
want only that categories subcategories to be available from the column b
drop down list.

I need help desperately - please
I have a tab in a spreadsheet (sheet 2) with about 200 rows (one column) of
text. I have another tab (sheet 1) in the same spreadsheet with about 16,000
rows of text.

I can use the function INDIRECT ("myRange") to create a reference for
my named range.
However, If I use INDIRECT("myArray") to use as a reference to my
named array I get a #REF! error.

I want to insert a timestamp when the value of a cell changes, so I can check
when the last time it changed.

I need to print my invoice but i need to have it so it prints numbers
consecutively example 1680,1681 what is the formula to do this

Is there anyway to have Excel autmatically make a new spreadsheet for each
break/change in grouping using the subtotal function?  I need to create
subtotals of a payment by ID# and then each ID# needs to be put into a new
spreadsheet so I can email this to the ID owner.  ...

Hello from Steved
I'm using excel 2007
I would like a formula please to change the date in Cell B2 if I make
changes to the data in the worksheet the range is C2:F550

Entering a number into a cell that is formatted as "general", and then
changing the format to "text" is not the same as formatting a blank cell as
"text" and then entering a number.  In the former, it is considered text, but
in the later method it is deemed a number but in text ...

Is it possible to copy a worksheet from one workbook to another workbook
without creating a link?

Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.
[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"
The above will formatt this $1,965,532 into this $2 Mil