| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing Top 30 with array-formula?
Hello there;
I have a list with values from A1:A2000 from which Iwould like to retrieve the Top 30 (largest values) in B1:B20? I think I have seen it done by a nice array-formula the otherday, but I cannot recreate, nor find it... Can someone help me out? Jen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA SHOWING AS #### | Excel Worksheet Functions | |||
| FORMULA NOT SHOWING VALUE | Excel Discussion (Misc queries) | |||
| Formula Showing Zero instead of nothing | Excel Discussion (Misc queries) | |||
| Sum Formula Showing Instead of Value :( | Excel Discussion (Misc queries) | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Threaded Mode
