Rfcolon428
New Member
- Joined
- Feb 1, 2019
- Messages
- 8
Hi, I been looking all over the place for a solution. I created two macros one to highlight the duplicates and other one to filter on the highlighted ones.
I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at a Col K. I want it to delete the ones that aren't the max or either highlight the max number, which ever is easier.
COLA COLK COL L
ABC 26 0
ABC 67 0
ABC 93 0
DEF 27 0
DEF 54 0
XYZ 200 30
XYZ 400 45
For ABC, we would keep 93.
For DEF, we would 54.
XY, we would keep 45.
I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at a Col K. I want it to delete the ones that aren't the max or either highlight the max number, which ever is easier.
COLA COLK COL L
ABC 26 0
ABC 67 0
ABC 93 0
DEF 27 0
DEF 54 0
XYZ 200 30
XYZ 400 45
For ABC, we would keep 93.
For DEF, we would 54.
XY, we would keep 45.
