Dear Expert,
I have two columns A&B for duplicate values. I want to find unique values for column A in compare to Column B and unique values for Column B compare to column A.
Can I do that by UNIQUE and FILTER function?
Dear Expert,
I have two columns A&B for duplicate values. I want to find unique values for column A in compare to Column B and unique values for Column B compare to column A.
Can I do that by UNIQUE and FILTER function?
It seems you must be on Excel Version MS365 if you're using UNIQUE. Please update your profile.
In D2, try:
=FILTER(A2:A8,COUNTIFS(B2:B8,A2:A8)=0)
In E2, try:
=FILTER(B2:B8,COUNTIFS(A2:A8,B2:B8)=0)
Wow, that's Great!
Thanks a lot.
One thing that confuses me, in countifs why you put another criteria range in criteria1. We should put only a criteria there not a range, right?
Could please explain how that is working.
COUNTIFS(B2:B8,A2:A8) is counting all the cells in B2:B8 that are equal to any of the cells in A2:A8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks