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...