Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Range including some blank rows
I am trying to find the last non-blank cell in a range that also contains
blanks. The data is a list of data with the corresponding date, but there will be blanks for days which are a Sunday or Holiday. The range increases every day, but I don't want to base the list on the day's relation to today because if someone is opening an older file it will not calculate correctly. An example is: 8/1 XX 8/2 XX 8/3 8/4 XX 8/5 XX 8/6 8/7 8/8 .... 8/31 <Summary data I want the system to pickup that 8/5 contains the last row of data in the range. I've been scratching my head over the formula for days without success. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Range including some blank rows
Assuming text (x or whatever) ,trying to match a non possible letter will
find the last row =MATCH("ZZZZZZ",b:b) -- Don Guillett Microsoft MVP Excel SalesAid Software "atryon" wrote in message ... I am trying to find the last non-blank cell in a range that also contains blanks. The data is a list of data with the corresponding date, but there will be blanks for days which are a Sunday or Holiday. The range increases every day, but I don't want to base the list on the day's relation to today because if someone is opening an older file it will not calculate correctly. An example is: 8/1 XX 8/2 XX 8/3 8/4 XX 8/5 XX 8/6 8/7 8/8 ... 8/31 <Summary data I want the system to pickup that 8/5 contains the last row of data in the range. I've been scratching my head over the formula for days without success. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a range in Excel without including hidden rows? | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
Subtotals including blank rows | Excel Discussion (Misc queries) |