Counting the ranks in a company without duplicates, multiple conditions
I need to count the ranks of people in a company. The problem I am having is too many duplicates in the data I'm given. I want to count the ranks with the conditions of: Division, Ranks, Loan Status. If the person is on loan, I don't want to count them. I left an example. Thanks.
Duplicate Employee Numbers.xlsx
hi nickmessick1. it's always good to give an eg of the desired results, so we can check if our results match yours. i think an array formula can help you but they don't like merged cells. so unmerge the cells in I11:J11. if you like to see them together for some reason; select them & right-click -> Format cells -> go to the Alignment Tab -> Horizontal: Center across selection -> OK
then use this formula in I11:
=SUM(IF(FREQUENCY(IF(A2:A20=I9,IF(B2:B20=I10,D2:D20)),D2:D20)>0,1))
you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. When done correctly, you should see curly brackets surrounding it
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Array formulas are great. I will be learning more about them. This got my desired results. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks