| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display the Cell Number of Cell if Value =Value
I need to figure out a way to look at a range of cell values (all numbers)
and return the cell number of where it falls within the list. Reference list in Column X (X3:x25000) # to look for in Cell Z10 Bsically if Z10 id found in X45, X76 and X5000; return 45,76,5000 in adjacent cells. I would like the cell #'s found to be listed next to the look for # either in line or row format. Does anyone have a code for this? TIA -- Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display date of today in cell X when number 0 in cell Y | Excel Worksheet Functions | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| have one cell display text which reflects a number in another cell | Excel Discussion (Misc queries) | |||
| a cell to display number of days in a month given in another cell | Excel Worksheet Functions | |||
| display a number in one cell as text in more than one cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
