Hi I'm looking for VBA help to remove rows of data that are not needed.
In column M I have a case number with multiple duplicate values. I need to only keep one based on the following criteria (SEE ATTACHMENT):
- If column K (W_TIME) is greater than 1 then keep row and delete other rows with same case number
else
- Find second highest value in column I (T_TIME) and delete other rows with the same case number.
My VBA skills are rusty and I have 10 files each with >200k lines that need to remove unecessary data before appending them all.
Thanks in advance!
Bookmarks