Hi,

I would like to use the TAKE and SORTBY functions together to extract the top and bottom 3 product names (in column A) based on annual sales (in column B).

I have the formula:

=TAKE(SORTBY($A$1:$A$100,$B$1:$B$100,-1),{3;-3})

The formula correctly returns the top and bottom selling product names if I have {1;-1} in the formula but it doesn't work properly if I use instead {3;-3}.

Can someone please suggest what's wrong with the formula shown above?

Thanks!