Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell ref
hi say i have in column a a list of numbers and i want to find the cell ref (column and row) of a specific number, can i do this? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=383496 |
#2
|
|||
|
|||
if there is only one occurance of the number
You can check by =countif(range,value) you can get the row and column by =sum(if(range=value,row(range),0)) entered as an array (control-shift-enter) and =sum(if(range=value,column(range),0)) also entered as an array if there is more than one occurance, it gets more complicated and depends on what you want to do with the information. "ceemo" wrote: hi say i have in column a a list of numbers and i want to find the cell ref (column and row) of a specific number, can i do this? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=383496 |
#3
|
|||
|
|||
Here's one way assuming your lookup range is f9:f13 and you are looking up
the value 222. adjust the ROW() and COLUMN() as your range (f9:f13) changes to other columns or start rows. =ADDRESS(MATCH(222,F9:F13,0)+ROW(F9)-1,COLUMN(F9)) "ceemo" wrote in message ... hi say i have in column a a list of numbers and i want to find the cell ref (column and row) of a specific number, can i do this? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=383496 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |