Hello everyone,
Is there any way to filter unique values from a column without using a macro/advanced filter/remove duplicates/pivot table?
In excel 2013 they introduced DISTINCT(<column>). I would need sth similar for Excel 2010/2007.
EG:
A: B:
ana ana
apa apa
aca aca
ala ala
apa asa
aca
asa
Thank you!
Assuming your data start in A1, in B1 put this.
Formula:
Please Login or Register to view this content.
In B2 and copy down this one.
Formula:Please Login or Register to view this content.
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.
Data starts in A2
Array formula (remember about Ctrl+Shift+Enter) in B2:
Please Login or Register to view this content.
Thank you guys!
And what if I have the column A with data and I want unique values in one single cell like text?
eg:
A:
ana
apa
ala
ica
apa
ian
cell B1: "ana,apa,ala,ica,ian"
any ideea?
Use Column B as helper and hidden column and use something like this in C1...
Formula:Please Login or Register to view this content.
Or you have to use VBA.
Please try this VBA UDF (Not mine)
Please Login or Register to view this content.
Please click 'Add reputation', if my answer helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks