danielrodrigo
New Member
- Joined
- Nov 15, 2019
- Messages
- 3
Hi
I Have a Table with a RANKING of employees like this:
<tbody>
</tbody>
With PROCV I select all "CATEGORY CHAMPIONS" like this:
<tbody>
</tbody>
THE PROBLEM:
I need to select next 6 "WILDCARD" employees - GENERAL (without category) - and WITHOUT the best results (the champions) - like this:
<tbody>
</tbody>
It's possible??
tks a lot !
I Have a Table with a RANKING of employees like this:
NAME | CATEGORY | POINTS |
JOHN | TECH | 100 |
MARK | AUDIO | 99 |
PAUL | VIDEO | 99 |
SARAH | TECH | 99 |
ANDY | TECH | 99 |
CARL | COMPUTER | 99 |
RAY | AUDIO | 98 |
DANNY | COMPUTER | 98 |
ELLEN | BAKERY | 98 |
CHARLES | BAKERY | 98 |
FRED | TECH | 98 |
HARRY | TECH | 97 |
<tbody>
</tbody>
With PROCV I select all "CATEGORY CHAMPIONS" like this:
NAME | CATEGORY | POINTS |
JOHN | TECH | 100 |
MARK | AUDIO | 99 |
PAUL | VIDEO | 99 |
CARL | COMPUTER | 99 |
ELLEN | BAKERY | 98 |
<tbody>
</tbody>
THE PROBLEM:
I need to select next 6 "WILDCARD" employees - GENERAL (without category) - and WITHOUT the best results (the champions) - like this:
NAME | CATEGORY | POINTS |
SARAH | TECH | 99 |
ANDY | TECH | 99 |
RAY | AUDIO | 98 |
DANNY | COMPUTER | 98 |
CHARLES | BAKERY | 98 |
FRED | TECH | 97 |
<tbody>
</tbody>
It's possible??
tks a lot !