# Extract the 2 Lowest %

J

#### jc9972003

Help
Can someone help me do a formula that would extract the 2 Lowest percent and howmany calls arrived for that day " its in one hour intervals and runs from 12am-11pm
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

C

#### Claus Busch

Am Thu, 25 Oct 2012 08:36:33 -0700 (PDT) schrieb (e-mail address removed):
Help
Can someone help me do a formula that would extract the 2 Lowest percent and howmany calls arrived for that day " its in one hour intervals and runs from 12am-11pm
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

Regards
Claus Busch

C

#### Claus Busch

Hi,

Am Thu, 25 Oct 2012 08:36:33 -0700 (PDT) schrieb (e-mail address removed):
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

J

#### jc9972003

Help Can someone help me do a formula that would extract the 2 Lowest percent and howmany calls arrived for that day " its in one hour intervals andruns from 12am-11pm 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

Thank you so Much Clause this work like a charm