I am trying to create a function that will take two columns of data
such as this:
field1 field2
d 977
a 87
c 768
b 756
b 754
a 75
d 743
c 686
e 67
a 655
a 565
b 54
c 54
e 456
c 445
c 445
e 378
d 333
And give me a result like this:
field1 field2 FunctionResult:
a 75 1
a 87 2
a 565 3
a 655 4
b 54 1
b 754 2
b 756 3
c 54 1
c 445 2
c 446 3
c 686 4
c 768 5
d 333 1
d 743 2
d 977 3
e 67 1
e 378 2
e 456 3
Notice the function result ranks the numberic column based on the
variable. Any function tips greatly appreciated!
RBollinger