Max Row Count

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Hi,

I am looking for a formula to return the count of rows in
a range from row 8 to last occupied cell.
In other words, I need to find the last used cell in
either of the columns.

Currently, I am using =MAX(COUNTA($B$8:$B$5000),COUNTA
($C$8:$C$5000),COUNTA($D$8:$D$5000),COUNTA
($E$8:$E$5000),COUNTA($F$8:$F$5000))

This is not a perfect one since it does not count blank
rows that may be in the range.

I have an UDF solution, but it does not work as expected
since sometimes it give weird results.

Thanks,
Greg
 
Back
Top