rankif ?? (2 column criteria)
Posted by Rey on August 19, 2001 3:02 AM
Hi folks, I've been sitting here and thinking about this for hours but I'm stumped. Any input would be much appreciated. I captured a small part of the screen to show you, I get lost trying to explain it :)
I'm trying to rank col LVR based on col TR. If TR =1 and TD =09-Jul-01 then I manually enter formula:
I'd like to copy the formula down the col
Col TR's value changes, the number 1 can repeat (or any other number) somewhere down the col that's why I had to involve the TD to try and isolate it.
I hope that made sense... thank you.