Formula to find identical values in same column of data.
I need to find a formula that will see identical values in a column of numerical data, and post a flag in a cell to warn the user to check those values for validity. Either a text warning such as "Check" or a change of cell colour if thats possible. Thanks in anticipation. Murray.
Last edited by murrayglue; 04-25-2011 at 07:20 AM.
Hi,
You can use Countif function with conditional formatting.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Thank you very much appreciated. I am done now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks