ricardo9316
New Member
- Joined
- Apr 17, 2014
- Messages
- 22
A | B |
100 | |
0 | |
80 | |
0 | |
60 | |
0 | |
40 | |
0 | |
20 | |
0 |
<tbody>
</tbody>
I'm trying to set up a formula that would give me the 5 largest values in B1:B5 while ignoring zeros in A1:A10
A | B |
100 | |
0 | |
80 | |
0 | |
60 | |
0 | |
40 | |
0 | |
20 | |
0 |
[FONT="]My Values[/FONT] | [FONT="]Large[/FONT] |
[FONT="]100[/FONT] | [FONT="]100[/FONT] |
[FONT="]0[/FONT] | [FONT="]80[/FONT] |
[FONT="]80[/FONT] | [FONT="]20[/FONT] |
[FONT="]0[/FONT] | [FONT="]-5[/FONT] |
[FONT="]-5[/FONT] | [FONT="]-100[/FONT] |
[FONT="]0[/FONT] | |
[FONT="]-100[/FONT] | |
[FONT="]0[/FONT] | |
[FONT="]20[/FONT] | |
[FONT="]0[/FONT] |