Formatting Axis Patterns

While the newer dynamic array functions are probably the simplest solution, using a pivot table is definitely simpler than the last solution proposed in the tip. To do so you just need to
1. Make sure the data in column A has a column heading in cell A1, such as Values.
2. Select the whole range of data, including the heading.
3. On the insert tab select Pivot table.
4. Select the location for the pivot table (it can be on the same sheet or on a New Worksheet) then press OK.
5. From the field list that shows up, drag the Values to the Rows area, and again to the Ʃ Values area. The latter will automatically
be assigned to Count of Values, unless all values are numeric. In such case you will need to right click in the Sum of Values
column that was created automatically and select Summarize values By Count.
6. Finally, you need to click on the down arrow beside the Row Labels, and select Value Filters - Greater than,
   and specify the value of 2 (or whatever number repetitions you want to ignore).

While this approach still requires several steps, in my opinion they are easier to follow than the helper-column approach from the tip. Also, if you are not familiar with pivot tables, be not afraid; they are really not that complicated once you start using them.

Even though this is not a formulaic approach Nolan asked for, it has additional benefits:
• It creates a sort of the helper column for you, but it is condensed to only unique Values,
• You can easily sort and filter the content of the pivot table by the Values or by the Count of Values.

If you are using MS365 you could include the TrimRange function into the 2 options using LET ie =LET(X,A1:.A3000 (hard to see but there is a "period" before the A3000) this way Excel only has to evaluate down to the last used cell in column A instead of the full 3000 rows. Technically possible for the option without the LET but there are some traps to this if the ranges are different columns.