stephanini
New Member
- Joined
- Jul 20, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I'm trying to rank a group with varying job titles in column E, and a % in column J. Using wildcards to combine the CSR I & CSR II in the same ranked group, however, when using the following formula, it appears that the wildcards aren't working and it's still ranking them based on the 2 different job titles instead of the ranking either job title together.
=IF(E91&"*"=E91&"*",COUNTIFS($E:$E,$E91&"*",$J:$J,">"&J91)+1,"")
=IF(E91&"*"=E91&"*",COUNTIFS($E:$E,$E91&"*",$J:$J,">"&J91)+1,"")