Formula that check for duplicate data in a column range
Hi all,
I'm trying to write a formula that check for duplicated data in column range and return result in onther column on the first and second instances.
I'm using COUNTIF in column F and get 0 result I have attached workbook as an sample.
Thank for any help
Eugh
Hi
Do you mean this?
=COUNTIF(CHQ,C6)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Use..
=IF(COUNTIF($C$6:C6,C6)>1,"Duplicate","")
Life's a spreadsheet, Excel!
Say thanks, Click *
Try this formula
=if(c6=$c$6:$c$17,"true","false")
regards,
raj.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks