Forum Discussion
VLOOKUP to return unique values on subsequent matched records
Hello, Microsoft Excel Community. I'm not sure if there is a VLOOKUP formula that will do what I need, but there must be something out in MS formula land to return accurate results for duplicative i...
Dear Mr. Simone
Please use "Filter" function, it's very useful function, where you can find duplicate and unique value as you need
Exp. =Filter("What Range you want","Where should lookup your logical value"="logical value","Optional")
In your case
Logical Value = 134883599
=Filter(a2:g4,a2:a3=a2,"data not found")
Please use "Filter" function, it's very useful function, where you can find duplicate and unique value as you need
Exp. =Filter("What Range you want","Where should lookup your logical value"="logical value","Optional")
In your case
Logical Value = 134883599
=Filter(a2:g4,a2:a3=a2,"data not found")
