Forum Discussion
Solved
Looking for Help to indentify duplicates which respect to conditions
Looking for a formula for getting the duplicate data based on the highest version and then copy adjacent row data in next rows . Example : InpUt Name Set Type Version 95591 Type 1...
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.
Can you share the code for the Above attached PDF - Which will Solve half of my problem.
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.