Forum Discussion
Looking for Help to indentify duplicates which respect to conditions
surya300810 Perhaps Power Query can do what you need. See attached file. Note that I changed some of the data as I believe it didn't coincide with the description/explanation in one of the screenshots you uploaded. I marked the changes yellow in the Input list.
I'm trying to understand what you want to do. Does the attached file show your intended result?
For example in the post there is the input
| Name | Set Type | Version |
| 95591 | Type 1 | - |
with the intended output:
| Name | Set Type | Version | |||
| 95591 | Type 1 | - | Type 1 |
However there isn't a duplicate for Name 95591 and Version - in the data.
The data in the pdf. file was entered manually. Unfortunately i can't help you with what you actually want to do. I can't suggest a solution to select the duplicate names of the highest version with a formula or VBA.
EDIT: You can click the button in cell H2 in the attached file to start the macro. This is the only solution i can offer. The result is what i entered manually in the pdf. file.