Thank you for your help!
Thank you for your help!
Last edited by srp123; 08-12-2012 at 10:48 AM.
Hi srp123,
Welcome to the forum.
Try using below formula:-
Formula:=IF(COUNTIF($A$1:$A11,$A11)>1,0,1)
See attached:- Duplicate indicator.xlsx
Any specific reason you are looking for Offset function?
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks