# Function needed to list unique ranking of callers based on multiple criteria.

1. ## Function needed to list unique ranking of callers based on multiple criteria.

Hello everyone, I'm new to this forum so I apologize for any errors or insuffient data I provide. I am trying to rank callers from the most experienced to least experienced. On our calling floor, we have three seats in a group, where the middle seat is for the most experienced caller to help out the side seaters. I cant find a function that will fit my needs. Attachment 636198 I have also pasted the data below. To ensure privacy of the callers, I've omitted the names. The ranks on the far left side are the result of using the function (seen also in the picture): =IF(A2>0, COUNTIFS(\$C\$2:\$C\$100,">"&C2,\$D\$2:\$D\$100,">"&D2, \$E\$2:\$E\$100, ">"&E2)+COUNTIFS(C2:\$C\$100,C2,D2:\$D\$100,D2, E2:\$E\$100, E2), 0). The if function is used to omit the zeros in the ranking system.

Caller Ranks Function.PNG

Rank Caller Days Total Raised Rating Count
5 58 1,500.00 3 4 Experienced
6 72 1,000.00 2 7 Inexperienced
7 58 100.00 1 2 Leftover
2 415 17,000.00 4
4 422 5,000.00 3
6 58 2,500.00 2
7 44 1,000.00 2
8 72 100.00 1
7 72 100.00 1
1 1073 40,578.35 5
2 1059 28,139.34 4
2 1066 39,566.17 4
6 72 100.00 1

2. ## Re: Function needed to list unique ranking of callers based on multiple criteria.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1