fin last row withtin a range using built functions not VBA
Luis,
You need to better describe your worksheet's structure, but a solution is
possible...
HTH,
Bernie
"LuisE" wrote in message
...
Bernie,
What if I need to find the corresponding last cell in the next Column (B).
in other words, the last non empty cell in B begining from the last non
empty
row in A
Thanks in advance
"LuisE" wrote:
I have blocks of data in a sheet, every time there is an entry in column
A a
new range begins and (in terms of rows) goes as far as until there is
another
entry in Column A.
All the entries in Column A are in A9 with "validation data list" i need
to
retireve the last row of the range of the selected entry using built in
formulas.
I have this to get the first row and it works
=MATCH( A9,$A$41:$A$10000,0)+40
Need the one to find the last row of that range which is delimited by the
next entry in ColA
Thanks in advance
|