Jul 13 2006, 03:32 PM
Could someone assist me with the correct syntax to perform the following:
I want to define a named ranged starting at cell B2 that expands down to the last entry based on column A. Column A has no empty cells and B does and the values are discontinuous.
In other words, create a dynamic range based on col B minus the first cell (B1) that includes as many remaining cells that are full in col A.
My attempts continue to add one extra cell at the very end of the range.
Jul 14 2006, 07:04 AM
I notice in your formula that you are counting the entire of column, by any chance does this also have a value in the first row that you need to ignore? I.e. do you have column headings.
Then it would just be:
Jul 14 2006, 08:38 AM
That did it. I would swear I tried that, but its hard to see the forest through the trees sometimes.
Jul 14 2006, 09:14 AM
Glad to help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here