| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Contents of adjacent cell from a function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Get current cell with VBA function | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Hiding a function value in a cell until function used | Excel Worksheet Functions | |||
Threaded Mode
