I am trying to figure out a formula to count duplicate items in ascending order. Here is an example. I have invoices from email automatically create a new row, but some vendors send a single file that has multiple invoices. So when we duplicate those rows I want to be able to visualize which duplicate it is.
It would also be nice to have a button that you can add the number of copies you want and it will duplicate it that way, but maybe I can figure that out later.
Any help would be appreciated. Thanks!