Hello.
I have "Table1" in my spreadsheet. it contains thousands of rows but there is data in first hundreds of rows only.
how can I find the last row of my data by disregarding the non-used rows of the table.
Thanks
Ahmed
Hello.
I have "Table1" in my spreadsheet. it contains thousands of rows but there is data in first hundreds of rows only.
how can I find the last row of my data by disregarding the non-used rows of the table.
Thanks
Ahmed
GUURE
How aboutPlease Login or Register to view this content.
You should have no reason to have a listobject with blank rows in the first place...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
@Axmed.cm, you are defeating the purpose of structured tables if you have thousands of rows of 'nothingness' absorbing your sort/filter operations.
Read up and apply the relevant procedures relevant to structured tables, their purpose and advantage is their self maintaining function.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks