LinkBack URL
About LinkBacks
ShaunDutton 
I did indeed...
Here's a screen shot of what it gave me...(see attached) hope this helps.
I did indeed...
Here's a screen shot of what it gave me...(see attached) hope this helps.
Perhaps your version of Excel requires argument separators to be semi colons instead of commas. Try:
confirmed with CTRL+SHIFT+ENTER
=COUNT(1/FREQUENCY(IF($B$2:$B$25=E2;IF($A$2:$A$25<>"";MATCH($A$2:$A$25;$A$2:$A$25;0)));ROW($A$2:$A$25)-ROW($A$2)+1))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Re: Uniue Values from 2 colums - Formula
Worked like a charm!!!Originally Posted by NBVC
Perhaps your version of Excel requires argument separators to be semi colons instead of commas. Try:
confirmed with CTRL+SHIFT+ENTER=COUNT(1/FREQUENCY(IF($B$2:$B$25=E2;IF($A$2:$A$25<>"";MATCH($A$2:$A$25;$A$2:$A$25;0)));ROW($A$2:$A$25)-ROW($A$2)+1))
Turns out I needed to use commas instead of semi-colons...not sure why that is. Thanks so much for your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks