Forum Discussion
Solved
Help finding the biggest (absolute terms) movement in order
Hi, I have a large set of data i update each day. I am hoping to fix a formula so i can find the large movement (either positive or negative) each day. I am looking to find the top 10 movers each...
If take sign into account that could be
=AGGREGATE(14,6,ABS($G$48:$G$2049),ROW()-ROW($B$9))*SIGN(INDEX($G$48:$G$2049,MATCH(AGGREGATE(14,6,ABS($G$48:$G$2049),ROW()-ROW($B$9)),ABS($G$48:$G$2049),0)))and for the name
=INDEX($A$48:$A$2049,MATCH($B10,$G$48:$G$2049,0))