rosafranco2020
New Member
- Joined
- Oct 9, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
hi all,
My formula to capture THE correct ranking is not working on triplicates.
I am using: =SUMPRODUCT((($A$2:$A$241=A5)*($L$2:$L$241<L5))/(COUNTIFS($L$2:$L$241,$L$2:$L$241,$A$2:$A$241,A5)+($A$2:$A$241<>A5)))+1
As you can see, for this particular example - the "thru date" of 08/31/2020 should be ranked at 2 not 1. Its possible, my formula is the issue.
Can you guys help me please? Sorry the XL2BB is not working on my computer though. Thank you for the infinite support
My formula to capture THE correct ranking is not working on triplicates.
I am using: =SUMPRODUCT((($A$2:$A$241=A5)*($L$2:$L$241<L5))/(COUNTIFS($L$2:$L$241,$L$2:$L$241,$A$2:$A$241,A5)+($A$2:$A$241<>A5)))+1
As you can see, for this particular example - the "thru date" of 08/31/2020 should be ranked at 2 not 1. Its possible, my formula is the issue.
Can you guys help me please? Sorry the XL2BB is not working on my computer though. Thank you for the infinite support