Comparing different size of tables

Hi all,

I have several type of tables which are differing by the amount of rows they have. Some of them are matching each other in terms of size but most of them are differing from each other. I have already created manually table size groups to categorize them.

I would like to create a formula that helps to identify which table category each of the tables are falling. It would be helpful to have a dynamic solution if new data comes in.

Thanks a lot in advance!

If size means number of rows, then I would suggest to use look for the first blank cell using =match() for each table and then categorize it.

Thanks a lot for your quick reply. Yes size means rows but the problem is that some of the rows containing blank cells within the tables. Do you have any solutions for that in mind?

I only know how to obtain the last row used by a macro