asked on
Excel
Is is possible to count Max salary of Male as well as Max Salary of Female in an organization. For Exp -
Name Gender Salary
Rohan M 60000
Peeyush M 40000
Smita F 55000
Gauri F 35000
and so on. Using Function
Name Gender Salary
Rohan M 60000
Peeyush M 40000
Smita F 55000
Gauri F 35000
and so on. Using Function
Microsoft Excel
Last Comment
Professor J
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Ha! Missed the MAX above - sorry
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks, Thanks a lot. I have got my aswer.
ASKER
Grateful for help.
You're welcome Manju! Glad we could help.
you are welcome manju
:)
:)
closed as follows
https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34