Forum Discussion
Excel: Finding Highest & Lowest Salaries by job title
Hi there I am trying to find a formula that will help complete the summary page in the example attached. I need to return the highest and lowest salaries by Job title. I tried VlookupMax and Min an...
Donald_Genes I read the comment in your file "Bonus! You can't use pivot table for this problem". I wonder what made you write that. The only sensible way to solve this is WITH a pivot table as suggested by Detlef_Lewin and use the Row label filter (or a slicer) to limit the output to the job title(s) desired.
See attached.
The question require formula not Pivot table! Not as if Pivot table can't be use! Infact i can use many other ways including Power query but sticking to the question which asked for formula to be used is the right Way