polska2180
Active Member
- Joined
- Oct 1, 2004
- Messages
- 384
- Office Version
- 365
Hi I have column F with $ in it and column G with Rank lowest to highest. So if the $ amount is the highest the rank would be 1 and next highest rank would be 2.
What I would like is in H2:h42 to look at highest rank and populate the amount from column H. So no matter what order F and G are in I want to have column H always go from 1...42.
Thanks for the help.
What I would like is in H2:h42 to look at highest rank and populate the amount from column H. So no matter what order F and G are in I want to have column H always go from 1...42.
Thanks for the help.