list direct debit info if entered > 12 times

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
if your name is in column A use the following formula in a different
column
=IF(COUNTIF(A:A,A1)>12,"Flag","")
copy this down for all rows
 
Excel query

I have a spread sheet that list monthly direct debits per person. The
spreadsheet is cumulative, so the same name will appear more than once.

My query is, is it possible to create a report or list that will flag up a
name if it has been entered more than 12 times.
 
Back
Top