Extracting data from a list without duplicate (repeating entry)
Hi Community, I need help with my template creation with regards to extracting data from another sheet with multiple criteria. I hope somebody could provide solution to my problem. On the file attached, sheet2 contains the raw data and sheet1 serves as the summary. My problem is on how to retrieve all the discipline, role, level, hourly rates without repetition due to different values in working hours, days, quantity. Right now it retrieves all the entry as long as it is unique in terms of the whole row. Here is the snap shot of the summary but I would like to retrieve instead. Basically it should retrieve only one entry for discipline, role, level and rate and calculate the rest for the hours, days and fee.
