I have a list (column) of three digit numbers (telephone area codes) that
have an adjacent listing of number of calls associated with each area code.
Elsewhere on the spreadsheet I use the Large function to determine the top
ten area codes by call volume. My problem is identifying the area code
associated with each of the top ten. Offset would seems to be the answer but
I don't know how to use the Large function as the reference in the Offset
function.
A B
201 15
202 25
203 12
zzz xxx

Top Ten
Area Codes Calls
? 25 =Large(b1:bxxx,1)
? 15 =Large(b1:bxxx,2)
? 12 =Large(b1:bxxx,3)

--
Thanks,
Nick