How to use Rank Function in NEXEL, IS it possible to use,What is the syntax.
Hi Expert,
Please do reply on this
Hi Prakash Singh,
you might want to have a look at this document: Nexel Complete Formulae library which should answer any questions. On Page 425 you'll find "RANK".
Kind Regards,
Helmut
Hi Helmut Heimann , I am using the function but not getting any result,Syntax that I am using is =Rank(@b,*,LastRow), But its not showing any result.Please do the path find for the same.
My Original Syntax is =RANK[@a;Range(*;*:Last Cell;*)]
your syntax should read as follows: "=rank( [@a;*;*], [@a;*;*;Range.whole] )", have a look at this example:
Don't forget to build this as a "single entity rule".
Thanks a ton , please keep in touch.