Numbering based on filters
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!
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! Read More
