Hello Guys,

I am stumped on how to do this and am hoping that someone can help.

I have a complex line number in Column C and the length of the line in Column S.

If the line number is a duplicate I need to only keep the line with the longest length.

Thanks for the help.