Putting 4 Actors values/numbers in an order

robert.mccarthyrobert.mccarthy Member Posts: 165
edited July 2012 in Working with GS (Mac)
Hi All,

I have an application which gives 4 actors a number (i.e. Actor 1 = 14, Actor 2 = 45, Actor 3=9, Actor 4 = 129 etc etc)

I need to put these actors in order of number, and then give each actor its position.

So for example, using the example above:

Actor 1 would be given position 2
Actor 2 would be given position 3
Actor 3 would be given position 1
Actor 4 would be given position 4

Is there an easy way to do this, and work out the position of them, without the long nested 'rules' I am currently considering.

Many thanks,

Rob

Comments

  • robert.mccarthyrobert.mccarthy Member Posts: 165
    UPDATE: Using Windows Creator, No Tables
  • robert.mccarthyrobert.mccarthy Member Posts: 165
    Anyone else around today who can help? :)
  • simo103simo103 Member, PRO Posts: 1,331
    @robert.mccarthy ... pretty sure you are stuck with nested rules ... I searched for formulas to do it for a project I was working on and found none.
  • robert.mccarthyrobert.mccarthy Member Posts: 165
    Yeah, for 8 actors just to find the top 3 positions (i.e. 1st, 2nd, 3rd) I have 37 nested rules.

    I can always share this (if it works) and people want to know how to do it.
Sign In or Register to comment.

© Vanilla Keystone Theme 2025