in Cell C1, try array formual and confirm with Ctrl+Shift+Enter instead of just enter
=LARGE(ABS(IF($A$1:$A$5000="REV",$B$1:$B$5000)),ROWS(C$1:C1))
and in Cell D1, try array formula and confirm with Ctrl+Shift+Enter instead of just enter
=LARGE(ABS($B$1:$B$5000),ROWS(D$1:D1))
and copy down
Bookmarks