Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for formula to identify next non-empty cell on another sheet
Need a formula to identify the next non-empty cell in a column. This
reference woud be used on another worksheet to do lookups against. Sheet 1 would have a value in cell C5. The next populated cell in column C on sheet 1 would be C13. On sheet 2, I'd like to identify that C13 is the starting point and so on. This would continue for up to 6 sheets, with sheet 3, finding the next non-empty cell after the one it found in sheet 2 C13, (sheet 3 finding the next non empty cell after C13 that it sound for sheet 2, lets say C22 from sheet 1 and each subsequent sheet identifying the next non empty cell in the sequence from sheet 1. Ideas? Thanks in advance. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy row with an empty cell for each row in a sheet | Excel Discussion (Misc queries) | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
Formula to identify cell with different value in list | Excel Worksheet Functions | |||
How to identify a cell without a formula | Excel Discussion (Misc queries) | |||
How do identify a blank cell in a formula | Excel Discussion (Misc queries) |