| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
top 5 number is LARGE function with N/Afields
Hi, I have a column with a bunch of numbers and some N/A fields. I would like to find out the top 5 numbers. I tried with =LARGE((A1:A1000), 1) =LARGE((A1:A1000), 2) =LARGE((A1:A1000), 3) =LARGE((A1:A1000), 4) =LARGE((A1:A1000), 5) however the numbers I am getting don't seem to be correct. did the N/A field affect the function? please advise. thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=518559 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does the number 1.26E-23 mean? Is it a large or small number | Excel Discussion (Misc queries) | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| Easy Reading - large number minus small number | New Users to Excel | |||
| How to sort number with text in large function? | Excel Worksheet Functions | |||
| Passing large number of variables to function | Excel Programming | |||
![owl527[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
