kathyb0527
09-09-2008, 02:04 PM
I have a spreadsheet that has the completion dates of various steps in a process. I need to get the average number of days between each step based on the number of units. I started using formulas, but I've already run into some problems (blank cells the most obvious). I've attached a small sample of the spreadsheet. The actual list will vary each quarter and probably be ~1000 rows. I also have to take the numbers and put them in a table for presentation.
I would prefer to do this in VBA (great learning experience), but I need a shove in the right direction.
Thanks,
Kathyb0527
I would prefer to do this in VBA (great learning experience), but I need a shove in the right direction.
Thanks,
Kathyb0527