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...
As variant
=SMALL( UNIQUE( FILTER(Data!B:B, Data!A:A = A2) ), 1)and
=LARGE( UNIQUE( FILTER(Data!B:B, Data!A:A = A2) ), 1)