Thread
:
Extract the 2 Lowest %
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Extract the 2 Lowest %
Hi,
Am Thu, 25 Oct 2012 08:36:33 -0700 (PDT) schrieb
:
This is what my date looks like
Interval % in Service Level Arrivals
10/24 12:00 AM 100% 2
10/24 1:00 AM 81% 1
10/24 2:00 AM 52% 1
10/24 3:00 AM 50% 4
10/24 4:00 AM 25% 4
10/24 5:00 AM 100% 7
On this one I would want the formula to extract (two lowest SL)for 10/24
10/24 4:00 AM 4
10/24 3:00 AM 4
in B12:
=SMALL($B$2:$B$7,ROW(A1))
in A12:
=INDEX(A2:A7,MATCH(B12,$B$2:$B$7,0))
in C12:
=VLOOKUP(B12,$B$2:$C$7,2,0)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch