Hello. I want to get some help on understanding a formula. The reason is that I want to use it for my job. I have created a spreadsheet to help with what I am having a tough time with.
This is the formula that I am using
{=IFERROR(INDEX(B3:B49,SMALL(IF(A3:A49=C$2,ROW(B3:B49)-MIN(ROW(B3:B49))+1),ROWS($C$3:C3))),"")}
I dont know why the odds are only showing.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
This is the formula that I am using
{=IFERROR(INDEX(B3:B49,SMALL(IF(A3:A49=C$2,ROW(B3:B49)-MIN(ROW(B3:B49))+1),ROWS($C$3:C3))),"")}
I dont know why the odds are only showing.
Date | Wattage | What I am getting | What I want |
12/12/2015 | 12/12/2015 | ||
12/12/2015 | 1 | 1 | 1 |
12/12/2015 | 2 | 3 | 2 |
12/12/2015 | 3 | 5 | 3 |
12/12/2015 | 4 | 7 | 4 |
12/12/2015 | 5 | 9 | 5 |
12/12/2015 | 6 | 11 | 6 |
12/12/2015 | 7 | 13 | 7 |
12/12/2015 | 8 | 15 | 8 |
12/12/2015 | 9 | 17 | 9 |
12/12/2015 | 10 | 19 | 10 |
12/12/2015 | 11 | 21 | 11 |
12/12/2015 | 12 | 23 | 12 |
12/12/2015 | 13 | 13 | |
12/12/2015 | 14 | 14 | |
12/12/2015 | 15 | 15 | |
12/12/2015 | 16 | 16 | |
12/12/2015 | 17 | 17 | |
12/12/2015 | 18 | 18 | |
12/12/2015 | 19 | 19 | |
12/12/2015 | 20 | 20 | |
12/12/2015 | 21 | 21 | |
12/12/2015 | 22 | 22 | |
12/12/2015 | 23 | 23 | |
12/13/2015 | 24 | ||
12/13/2015 | 25 | ||
12/13/2015 | 26 | ||
12/13/2015 | 27 | ||
12/13/2015 | 28 | ||
12/13/2015 | 29 | ||
12/13/2015 | 30 | ||
12/13/2015 | 31 | ||
12/13/2015 | 32 | ||
12/13/2015 | 33 | ||
12/13/2015 | 34 | ||
12/13/2015 | 35 | ||
12/13/2015 | 36 | ||
12/13/2015 | 37 | ||
12/13/2015 | 38 | ||
12/13/2015 | 39 | ||
12/13/2015 | 40 | ||
12/13/2015 | 41 | ||
12/13/2015 | 42 | ||
12/13/2015 | 43 | ||
12/13/2015 | 44 | ||
12/13/2015 | 45 | ||
12/13/2015 | 46 | ||
12/13/2015 | 47 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>