Andy_Leslie
New Member
I'm trying to collate data in the attached file. I need to be able to sort and collate data based on 3 variable columns and a range of possible choices.
X has 2 variables 1 or 3, Y has 6 variables 1 thru 6, and Z has 11 choices A thru K. I first need to group all X choices to then calculate the total time and cubic meters per pond then allocate this per irrigator then per block and then display the total flow per block per pond.
Thanks for any help.
Andy
X has 2 variables 1 or 3, Y has 6 variables 1 thru 6, and Z has 11 choices A thru K. I first need to group all X choices to then calculate the total time and cubic meters per pond then allocate this per irrigator then per block and then display the total flow per block per pond.
Thanks for any help.
Andy
Attachments

16.7 KB Views: 9