Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scanning down a column
I want to scan down a data series in a column and look at the value of
each cell in cell G4. I can do this in a Macro, but I would like to do it with formula using Function Key F9. e.f. Formula in Range("G4") = "=A1" will advance to Range("G4") = "=A2", Range("G4") = "=A3" and so on with each calculation. To begin, I will have Range("G2") = "=G1 + 1" : Range("G1") = "=G2" which are circular. Formula in Range("G4") will look something like Range("G2") = "=A" & Range("G1") Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |