I have a list of job titles, with corresponding wage rates, there is more than one of each job title, with their respective wage rates.
I am trying to consolidate the list, to only show one of each job title, with the output of max, min and average wage rates for each title.
Is this possible?
In the attached spread sheet, the required output is indicated in red
Bookmarks