View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Vlookup data wrong if the small value found are same

.. smallest 8

To really cater for the event of ties, or multiple ties happening, think we
would probably need to fill down (viz. fill F2:L2, or K2:N2 down) beyond 8
rows to extract the top 8 (or bottom 8) list, and then read it off from
there.

--
Max, Singapore GMT+8, xl97
Samples archive at: http://savefile.com/projects/236895
xdemechanik
--