Hi,
I have the following groups and values
a 5
b 6
c 7
a 35
a 36
c 32
c 9
b 8
What I'd like to do is rank each value but within its own group (rank all the As together, B's together, and C's together).
any ideas?
I wish there was a rankif(), but no such luck.
thanks!
-joel
Bookmarks