Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the 2 Lowest %
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the 2 Lowest %
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the 2 Lowest %
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the 2 Lowest %
On Thursday, October 25, 2012 10:36:33 AM UTC-5, wrote:
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 Thank you so Much Clause this work like a charm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
HOW TO SEE/EXTRACT LOWEST PRICE OF MULTIPLE PARTS IN ONE PAGE | Excel Programming | |||
How do I: Extract column headers based on lowest number in sequence | Excel Worksheet Functions | |||
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |