Is it possible to use Percentrank as a CSE function.
I have something like this:
=PERCENTRANK(IF($D$3:$D$30=$D$31,TRUNC($C$3:$C$30,2),FALSE),$C$31)
Where $D$3:$D$30=$D$31 is the condition to be evaluated, and TRUNC($C$3:$C$30,2) would be returned.
Is it possible to use Percentrank as a CSE function.
I have something like this:
=PERCENTRANK(IF($D$3:$D$30=$D$31,TRUNC($C$3:$C$30,2),FALSE),$C$31)
Where $D$3:$D$30=$D$31 is the condition to be evaluated, and TRUNC($C$3:$C$30,2) would be returned.
Posting Permissions
Reply With Quote