pacerfan07
New Member
- Joined
- Jun 2, 2017
- Messages
- 20
Hi,
I'm trying to take a list of values in Column A, then in Column B define which ones are "high ranked" and which are "low ranked" So if I have the table shown below, I 'd like to take the top two values in column A and in column B label those as "high" and the bottom two should show as "low". The middle two are "avg." Thanks!
<tbody>
</tbody>
I'm trying to take a list of values in Column A, then in Column B define which ones are "high ranked" and which are "low ranked" So if I have the table shown below, I 'd like to take the top two values in column A and in column B label those as "high" and the bottom two should show as "low". The middle two are "avg." Thanks!
A | B | |
1 | 30 | |
2 | 40 | |
3 | 80 | |
4 | 20 | |
5 | 15 | |
6 | 50 | |
<tbody>
</tbody>
Last edited: