Hello,
I have a problem.If the value in column B is equal then depending on value in column D, i need to delete row with the highest value(in absolute value).
Column B Column D
x=25.75 125.00
x=25.75 98.00
x=25.75 76
x=13.34 -679.74
x=13.34 -693.57
x=26.68 59.65
x=26.68 59.65
the result:
Column B Column D
x=25.75 125.00
x=13.34 -693.57
x=26.68 59.65
Any advice is well taken.
Cheers.
Bookmarks