Thread: Hi to Low
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Hi to Low

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,
--
David