How to count no. of rows in the excel. Pls. help with the formula, Thanks in advance.
How to count no. of rows in the excel. Pls. help with the formula, Thanks in advance.
Check out the Rows() function in Excel help...
You will need to be more descriptive of what exactly you are trying to do for a more precise answer.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
hi
Another function that you can check out in the Help files is "=counta(..." which counts the cells within a defined range that have an entry in them.
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks