Selective Counter Column
For the purpose of tiered pricing, I am trying to add a column to a sheet that tracks the instance number of a row with a particular property.
For example: I add an row/item, enter 'medium' in the size column, and the formula in question picks up that this is the third 'medium' item in the sheet, counting from the top. It then generates the string 'M3' and does not change the data when another medium is added.
Help Article Resources
Check out the Formula Handbook template!