Max & Min Value with multiple criteria

[Kamran01]

Hello Experts,

I need you help to calculate max and min values Based on Designations.
Any suggestion please.

Thanks, Kamran Noor
[TABLE="width: 446"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]NAME
[/TD]
[TD]DESIGNATION
[/TD]
[TD]PAYROLL
[/TD]
[/TR]
[TR]
[TD]SAIRA MALIK [/TD]
[TD]ASSISTANT[/TD]
[TD] 19,180
[/TD]
[/TR]
[TR]
[TD]FAIZA ALI [/TD]
[TD]ASSISTANT[/TD]
[TD] 19,970
[/TD]
[/TR]
[TR]
[TD]MUHAMMAD IMTIAZ[/TD]
[TD]GARMENT ENGINEER[/TD]
[TD] 28,787[/TD]
[/TR]
[TR]
[TD]ZAINAB [/TD]
[TD]INCHARGE[/TD]
[TD] 23,730[/TD]
[/TR]
[TR]
[TD]MAQBOOL AHMED[/TD]
[TD]INCHARGE[/TD]
[TD] 45,397[/TD]
[/TR]
[TR]
[TD]ABDUL REHMAN[/TD]
[TD]INCHARGE[/TD]
[TD] 43,197[/TD]
[/TR]
[TR]
[TD]TANZEEM HUSSAIN [/TD]
[TD]MACHINE MAINTENANCE EXECUTIVE[/TD]
[TD] 27,818[/TD]
[/TR]
[TR]
[TD]SHER MUHAMMAD KHAN[/TD]
[TD]MACHINE MAINTENANCE OFFICER[/TD]
[TD] 26,815[/TD]
[/TR]
[TR]
[TD]MUHAMMAD YOUSUF KHAN[/TD]
[TD]MACHINE MAINTENANCE OFFICER[/TD]
[TD] 27,500[/TD]
[/TR]
[TR]
[TD]NASIR ALI [/TD]
[TD]MACHINE MAINTENANCE OFFICER[/TD]
[TD] 26,229[/TD]
[/TR]
[TR]
[TD]SHAHIDA [/TD]
[TD]MACHINE MAINTENANCE OFFICER[/TD]
[TD] 25,600[/TD]
[/TR]
[TR]
[TD]MARIYAM ZAHID [/TD]
[TD]MACHINE MAINTENANCE OFFICER[/TD]
[TD] 27,110[/TD]
[/TR]
[TR]
[TD]ABDUL REHMAN[/TD]
[TD]MANAGER[/TD]
[TD] 157,292[/TD]
[/TR]
[TR]
[TD]SADAF [/TD]
[TD]OFFICER[/TD]
[TD] 23,419
[/TD]
[/TR]
</tbody>[/TABLE]

 

[SteveO59L]

have you considered a pivot table?