Hey everyone,
I am currently doing a project and have hit a wall. I have a table with the names of an item, then they are in columns with their Qty, as below.
<tbody>
</tbody>
What I need is to extract the top 5 items along with their corresponding Item name (A-D), Qty (Qty1-4) and the value.
I know the conditional format can do this which highlights the items, but I'm after the values. PLZ HELP ME
I am currently doing a project and have hit a wall. I have a table with the names of an item, then they are in columns with their Qty, as below.
Item | Qty 1 | Qty 2 | Qty 3 | Qty 4 |
A | 1 | 16 | 7 | 8 |
B | 10 | 11 | 2 | 9 |
C | 3 | 6 | 15 | 14 |
D | 4 | 12 | 13 | 5 |
<tbody>
</tbody>
What I need is to extract the top 5 items along with their corresponding Item name (A-D), Qty (Qty1-4) and the value.
I know the conditional format can do this which highlights the items, but I'm after the values. PLZ HELP ME