I want to know if there are two coloumn a and b, In a we have name and b we have salary, Suppose there is a name sandeep thrice in column A and In Column B sandeep has three different salary. So How can we find out which sandeep had maximum or minimum Salary.
Thanks
Gajender
Are you allowed to use helper cells?
If so, I can suggest you to create a cell in which, through data validation you get your employee name. Then, create a cell under which you will put the "Highest Salary" and one in which you will put the "Minimum Salary".
Then, you can work as follows, supposing your "employee name" is sitting in E2 :
For the Max Salary : =MAX(IF(A:A=E2,B:B))
For the Min Salary : =MIN(IF(A:A=E2,B:B))
Both of these are "Array formulas" and require to be entered through the keyboard shortcut CTRL+SHIFT+ENTER
As you didn't specify the size of your dataset, the formula will look through the whole column A and the whole column B, this can be adjusted if needed.
Afterwards, you can work with conditional formatting to highlight the cells which have the employee name and the minimum salary in red (or whichever colour you prefer) and the maximum salary in green.
Supposing you have put the formula for the Max Salary in F2 you can use this rule to do the highlight : =AND($B1=$F$2,$A1=$E$2) and this one for the Min Salary - supposing you put the formula for the Min Salary in G2 : =AND($A1=$E$2,$B1=$G$2). Apply the formatting to either the whole columns or just your range.
I would post the sample sheet with the embedded formulas in html but I'm at work and don't have the HMTL add-in installed.
Hope this helps you.
