Try this ...

=INDIRECT("A"&MATCH(LARGE(C2:C10,1),C2:C10,0))&",
"&INDIRECT("A"&MATCH(LARGE(C2:C10,2),C2:C10,0) )&",
"&INDIRECT("A"&MATCH(LARGE(C2:C10,3),C2:C10,0) )

Assumed that your data is from C2:C10

*** Please do rate ***





"TUNGANA KURMA RAJU" wrote:

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