Formula to count text and alert me if a text appears more than twi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a column of text and I need to be alerted if the same text appears
more than twice in the column. The column changes on a regular basis. e.g.

Tom
Tom
Jane
Mary
Tom

"ALERT AN ITEM APPEARS MORE THAN TWICE"

Thanks Mike
 
Select the column (say it's Col D), use Data/Validation, change Allow Any
Value to Allow Custom, enter =COUNTIF(D:D,D1)=1, then choose an appropriate
error message on the error tab if you wish. This won't change any already
existing duplicates, but you can find those by tools/auditing/show auditing
toolbar, then click the "circle Invalid Data" toorbar button (looks like a
gridline with red circles)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula containing text 2
formula to count text entries and return text with most entries 8
Counting a series of text and/or numbers within columns 17
Formula help 1
Check text in a range 3
All Text Does Not Appear in Some Cells 2
Counting number of times a specific word appears in a single cell 19
Splitting text using an HTML tage as the identifying place to brea 2

Back
Top