Hi I need a formula to create list of sequential numbers based on certain criteria, however, the criteria may be mixed.
For example, based on this list here
this spreadsheet formula works well… =IF(A2<>A1,1,B1+1)
However, my list will not be sorted and the numbers must be sequential. For example my list may contain…
|Lot # (this will be my seq number)||Flavour|
I need a way to sequentially number the entries based on the criteria regardless of the order. Any ideas? I think I will need the MAX expression some how I just need a little help