Asheesh
Excel Ninja
Hi All,
I am sure this one is easy for you guys here; however, the intention is to check if there is a shorter and a better way of doing this with the help of excel formulae only
One of my colleagues approached me this morning and asked if there is any formula approach to get the unique count of matches between two lists. Though I came up with a solution which is 89 characters long without an equal “=” sign, I still think it can be improvised.
Limitations:
As per the attached, the result should be 5.
Unique matches between the two lists are Dashboard, Cursor, 55, 7986 & 21
I am sure this one is easy for you guys here; however, the intention is to check if there is a shorter and a better way of doing this with the help of excel formulae only
One of my colleagues approached me this morning and asked if there is any formula approach to get the unique count of matches between two lists. Though I came up with a solution which is 89 characters long without an equal “=” sign, I still think it can be improvised.
Limitations:
- Lists may or may not have blanks
- Lists may contain numbers or text values
- Both ranges may or may not be equal
- No named ranges to be used.
- No helper cells please
As per the attached, the result should be 5.
Unique matches between the two lists are Dashboard, Cursor, 55, 7986 & 21
Attachments
Last edited: