Hi!
I have a spreadsheet with a list of 70 items. I have a filter for this list - 59 entries are "A", 11 entries are "B". All As and Bs are in random order.
I would like to have an additional column in which all items A are numbered from 1 to 59 when I apply the filter "A" to my list and all items B should be numbered from 1 to 11 when I apply the filter "B" to my list.
How do I do that?
Thanks in advance!
