Tally Duplicates Under First Occurrence

Dpriester

I have a count of incidents for each location. The "rank helper" column use to total the number of incidents beside the first occurrence of a name. For example: Bellflower has "2" incidents. I want the first listing for Bellflower to show the "2" in the "rank helper" column and additional Bellflower occurrences not display a number. Basically, the first Bellflower occurrence shows the tally for all.

Paul Newcome

You would need to insert an auto-number column with no special formatting. Then you would use this to generate your counts:

=IF([Auto-Number]@row = MIN(COLLECT([Auto-Number]:[Auto-Number], [Center Name]:[Center Name], @cell = [Center Name]@row)), COUNTIFS([Center Name]:[Center Name], @cell = [Center Name]@row))

Dpriester

This is how is used to be: The first occurrence of Chicago Maywood keeps the tally for all Chicago Maywood occurrences in the Rank Helper column. The remaining occurrences are blank in the Rank Helper column.

Paul Newcome

You would need to insert an auto-number column with no special formatting. Then you would use this to generate your counts:

=IF([Auto-Number]@row = MIN(COLLECT([Auto-Number]:[Auto-Number], [Center Name]:[Center Name], @cell = [Center Name]@row)), COUNTIFS([Center Name]:[Center Name], @cell = [Center Name]@row))

Dpriester

Thank you, Paul! Works great!

Paul Newcome

Happy to help. 👍️