Home ยป Auto Checking Duplicate Entries
Posted by Anonymous December 1, 2008 - 10:43am

If you use this countif function in conditional formatting (after selecting column A), it will automatically highlight any duplicate value in column A (without the need for using column B).

Word and Excel Training

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
More information about formatting options Captcha Image: you will need to recognize the text in it.
Please type in the letters/numbers that are shown in the image above.