I have a pivot table (according to the attached sample file).
This table contains names in column B started from cell B12. The next name will be in the previous cell reference + 14rows (B26-B40-B54 so on).
I would like to insert automatic numbers (in ascending order) in Column A to indicate the names with numbers except the TOTAL data (after the names).
Has somebody got a good solution for this problem?
Bookmarks