LinkBack URL
About LinkBacks
I have a set of spreadsheets and each one has a blank line somewhere in the middle area. I need a formula that I can place at the bottom of each spreadsheet that returns the row number of the blank row in each one. All help is very appreciated!
I have a set of spreadsheets and each one has a blank line somewhere in the middle area. I need a formula that I can place at the bottom of each spreadsheet that returns the row number of the blank row in each one. All help is very appreciated!
As a option, you can have a calculated column on the right side of your data where you can use counta function to count the entries in that row.
Now at the bottom of the data, you can have a Match function to find the row number, see attached:-
finding blank row number.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks