Thread: top 5 number is LARGE function with N/Afields
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
owl527[_24_] owl527[_24_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote