Hi,
I have a spreadsheet filled with an employees' checking times. I want to remove the bottom and top ten percent of checking times per day. However, there are hundreds on days within the spreadsheet and all the days are in the Date Column. I'm assuming a if - percentile function would be the best way to isolate these bottom and top times but I can only do that for all the days as a whole. I need to do this per day over the course of many days. How do I loop the percentile function over the course of a days?
Basically, is it better to do a vba loop over the days (using the days as a variable) or can I apply the percentile function as an array over the days.
Any advice and actual sample script would be wonderful!
Nikita
I have a spreadsheet filled with an employees' checking times. I want to remove the bottom and top ten percent of checking times per day. However, there are hundreds on days within the spreadsheet and all the days are in the Date Column. I'm assuming a if - percentile function would be the best way to isolate these bottom and top times but I can only do that for all the days as a whole. I need to do this per day over the course of many days. How do I loop the percentile function over the course of a days?
Basically, is it better to do a vba loop over the days (using the days as a variable) or can I apply the percentile function as an array over the days.
Any advice and actual sample script would be wonderful!
Nikita