Monthly percentage greater than a value

E

eidde1

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 helpwith this would be greatly appreciated.

Thanks
Eddie
 
E

eidde1

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
Click to expand...

Sorted this with a pivot table in the end. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop cells, add rows and transpose for values greater than zero 1
Using SUMPRODUCT Function on Calculated (Function-Derived) Data 6
Data from 2 sheets to create a new sheet with user input? 1
Determine Resource Allocations by evaluating available time and required time. 3
Averaging values 1
vlookup and match first value greater than 4
Transfer data between two worksheets 10
Copy cell based on unique value - alternate rows - into 1 row,.... 0

Top