Hi to Low

[David]

Hi Group,

I have 4 varaibles, to keep it simple:
a=2
b=1
c=5
d=0

I am looking for code that will rank them largest to smallest. It was much
harder to accomplish than I thought it would be. I have started with
If a > b And a > c And a > d Then
FirstLarge = a
If b > c And b > d Then
SecondLarge = c
etc.

But I thought someone might have thought this through already. Anyne done
this?

Thanks,

 

[ozgrid.com]

Use the RANK function. Other Functions that maybe of use are: SMALL & LARGE.

 

[David]

Thank you. I have not been able to try this out, but it looks like it will
work.

I knew there had to be a better way than I was trying.

Thanks,