Sanzay Kumar
New Member
Hello,
I was wondering if the following can be done. Basically, I need to extract a summary from a data set (I have attached an example) into a separate sheet so I can export easily as a report.
The summary should add up the hours based on location, date and service. Some of the services are to be combined, in the example, you will notice that the hours for Domestic RRD and CTL RRD are added together for the same location and date.
Any help would be appreciated!
Thank you!
I was wondering if the following can be done. Basically, I need to extract a summary from a data set (I have attached an example) into a separate sheet so I can export easily as a report.
The summary should add up the hours based on location, date and service. Some of the services are to be combined, in the example, you will notice that the hours for Domestic RRD and CTL RRD are added together for the same location and date.
Any help would be appreciated!
Thank you!