Selective Counter Column

Greg Sheppard

Hello Everyone,

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.

Thanks!

Greg

Paul Newcome

Try something along the lines of

="M" + COUNTIFS([Size Column]$1:[Size Column]@row, [Size Column]@row)