Hi all,
I would greatly appreciate help on the following problem
I have data showing depths drilled during each particular day for example
Hole 1 Hole 2 Start Finish Start Finish 20 180 0 250
And I want to automatically populate these cells to give a break down of how much was drilled in each region
0-50 51-100 101-150 151-200 201-250 251-300 301-350 ? ? ? ? ? ? ?
the answers for the above example would be;
0-50 51-100 101-150 151-200 201-250 251-300 301-350 80 100 100 80 50 0 0
Does anyone have any idea what formular I should use?
Thanks in advance.
Alex
Bookmarks