Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rank based array function
col A------ col B--------col C-------------col D-------------col E
names----job----------PresentSalary---EarlierSalary---- joe--------assistant---100----------------90 beck------secretary---110----------------100 george---manager----90-----------------100 kent------manager----210----------------180 lucy-------clerk--------23------------------26 mary------technician--500---------------498 murty-----clerk--------72-----------------76 lara-------chiefclerk---255----------------245 ibrahim---assistant----106---------------112 I am looking for a w/sheet array function that returns Top 3 gainers( salary gain percentage) from range A2:D10 without creating a helper column.I tried with abs,offset,large,and rank functions,but not succeeded.Also 3 Top Losers function. Results of formula be in E2:E4=(top 3 gainers)=kent,joe,beck Results of Formula be in F2:F4=(top 3 losers)=lucy,george,ibrahim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank Function | Excel Discussion (Misc queries) | |||
numerical integration | Excel Discussion (Misc queries) | |||
defintion of array function | Excel Discussion (Misc queries) | |||
Array | Excel Worksheet Functions | |||
Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) |