LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Top 90% of records - Bring out number

Have the oddest SLA requirement I've ever been asked to have a look at,
hope you can help.

Basically have a set of data of closed records for 2005.

My manager wants to show of the closed records how many days were 90%
of them completed?

She is looking at this as a 'best case' scenario, so therefore in
simplistic terms this means:

If there were 50 records closed, look at 90% of these records (in
shortest amount of days order) and give the highest number once at 90%.

e.g. (with a small dataset). There are 50 records. The largest number
of the dataset once sorted is 20 (at the 45th record).

Hope this makes sense, any questions please let me know.

Thanks, Al (mralmackay)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
making a number be text Fredrated Excel Worksheet Functions 2 June 1st 05 02:37 AM
Maximum number of rows? Allan Bach Excel Discussion (Misc queries) 5 April 14th 05 12:37 PM
Number of records by Month that meet a specific requirement Keith Brown Excel Worksheet Functions 1 February 5th 05 05:42 PM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 09:01 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"