Assigning numbers to every group in a set of data
Hi. I have a list of names that need to be grouped and numbered. I have a problem with the formula that assigns the number in each group where the names are not listed in consecutive rows.
I have attached a sample sheet.
Thank you.
|