| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
large function result as reference for offset function
Dears,
I used to use LARGE function to bring the 5 largest deals from another worksheet (database, same workbook), but I want to bring also the related cells (same row), so I would be able to show, for instance, company, close, date and amount. How can I extract the cell name reference to retrieve it in another cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| Can I use LOOKUP as the reference in OFFSET function? | Excel Discussion (Misc queries) | |||
| Dynamic reference in OFFSET function | Excel Worksheet Functions | |||
| how do i get field name from result of MAX or LARGE function | Excel Worksheet Functions | |||
| LARGE function file reference | Excel Discussion (Misc queries) | |||
Threaded Mode
