Hi folks,
Please see sheet attached.
In column A i want to paste a list.
In column B i need it to use a formula to remove any duplicates from this list
In column C i need it to count how many of this unique entries are contained in Column A.
Is it possible to use a formula to scan Column A and paste a unique list in column B
Last edited by controlfreak; 09-05-2013 at 11:42 AM.
Hi Manolis.
In B2 and copy down use this.
=IF(INDEX($A$2:$A$100,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$100),0,0),0))=0,"",INDEX($A$2:$A$100,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$100),0,0),0)))
In C2
=COUNTIF(A:A,B2)
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.
Fotis I think i love you!!
Will you marrying me?
maybe!!
Efkharisto poli!
You are welcome(Parakalo!) and thanks for the feed back & rep *.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks