Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find ROW(INDIRECT()) wo the column letters
hi, had it before, cannot remember setup for formula to indirect a reference
to a row, without having to enter a column, i.e.: =ROW(INDIRECT($AP$11))<ROW($AP$208) AP11 = AP208, answer = false (works), but need to be able to just enter the row number in AP11. maybe did not even use INDIRECT.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I find the number of letters in a cell? | Excel Discussion (Misc queries) | |||
Indirect with COLUMN | Excel Worksheet Functions | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
SORT A LIST OF NUMBERS AND LETTERS A,B,C,D AND FIND MAX | Excel Worksheet Functions | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions |