Help required to Rank Numbers Positive to Negative

[Dinesh121]

Hey All,


I have a scenario where I have to rank positive to negative and also to ignore zero's. I have attached a sample workbook. Any help would be much appreciated.


-Dinesh


Download link for sample wbk:

http://www.fileconvoy.com/dfl.php?id=gd08bec0452a32e45999269815da70cd365334f4c5

 

[NARAYANK991]

Hi Dinesh ,


You can use the following formulae :


In F2 : =LARGE(IF($B$2:$B$13<>0,$B$2:$B$13,-999999999999),D2) entered as an array formula , using CTRL SHIFT ENTER.


In E2 : =INDEX($A$2:$A$13,MATCH(F2,$B$2:$B$13,0))


Narayan

 

[Dinesh121]

Hey Narayank,


thanks a lot for the Quick reply.. Formula works great.


Thanks Again.


-Dinesh