Thread: INDEX MATCH SMALL
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default INDEX MATCH SMALL
Hi,

Am Mon, 29 Oct 2012 14:27:15 -0700 (PDT) schrieb :

I was able to view the file, and the formula is only retreiving the first 2 rows of data no matter what SL % or dates I put...

if you sort your table by days and SL, the first 2 rows have the 2
smallest SL


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote