Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
A 6-column by 50-row range (a1:f50) is filled with random numbers. The
numbers are from 1 to, say, 100. What Excel function, written in a serarate cell, will return the cell location of the first occurence of a given number as we read the cells from left to right and from top to bottom in the range? (e.g., "73" occurs in cells D32, A56, B88 and F97. D32 would be the 'earliest occurence'. What operator, function or formula would report back "D32"?) From a college class a long time ago, I seem to recall another kind of spreadsheet that could do that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
hyperlink an excel cell to a specific location wthin application f | New Users to Excel | |||
Linked cell location of hyperlink | Excel Worksheet Functions |