LinkBack URL
About LinkBacks
I am looking to display the one unique item from a list
1
2
1
1
1
1
So I need to display the number 2 as the only unique item in the list.
Cheers
JD
I am looking to display the one unique item from a list
1
2
1
1
1
1
So I need to display the number 2 as the only unique item in the list.
Cheers
JD
Try this array formula**:
=INDEX(A2:A7,MATCH(1,COUNTIF(A2:A7,A2:A7),0))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Awesome answer, cheers Tony life saver again pal
John
You're welcome. Thanks for the feedback!
Bugger! Id come up with a UDF
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks