Forum Discussion
RANK IF
Hi
I need to create the rank function based on the below example
Example:
IF A Value is >
AND IF B Value is <
AND IF C Value is >
AND IF D Value is <
Based on the above Values & condition I want to create the Rank with top 10 ... please help
4 Replies
v-jiascu-msft DatatouilleTomMartensMattAllington please help me on the above
Its based on One Value
Hi chethan,
I'm wondering if you could use the formula below to create a new calculate column "E" in your table first, then use rank function based on the column "E" to get your expected result in this scenario? :smileylol:
E = A*1000-B*100+C*10-D
Regards
