So I want to find the top 5 absolute values for a data set but only for a specific criteria (say only by client 1 instead of all clients) and have been having a tough time getting that to work.
I have been using an IF statement but I'm not sure that's what I want to be using:

Formulas:
=IF(A:A="Client Name 1", LARGE(ABS(B:B)), 1, "") CTRL+ENTER
=IF(A:A="Client Name 1", LARGE(ABS(B:B)), 2, "") CTRL+ENTER
.....
=IF(A:A="Client Name 1", LARGE(ABS(B:B)), 5, "") CTRL+ENTER

Any ideas or suggestions, please post a reply. Thanks a lot!
Scott