View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eidde1@gmail.com is offline
external usenet poster
 
Posts: 21
Default Monthly percentage greater than a value

On Tuesday, 28 January 2014 02:17:52 UTC, wrote:
Hi all

I have a spreadsheet with nearly 19,000 rows of data. It contains turnaround times in hours for two years of laboratory data. Col J is the turnaround time in hours and Col D is sample date. I would like to work out monthly percentages of turnaround times 4 hours (which is the target TAT). Any help with this would be greatly appreciated.



Thanks

Eddie


Sorted this with a pivot table in the end. Thanks