Need help with a fomrmula

[mduntley]

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.

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>

 

[AhoyNC]

You need to lock your ranges. Right now as you move down a cell your range changes. Also, I don't see the need for the MIN in your formula.

Try changing your formula to (it's still an array formula that must be entered with CTRL-SHIFT-ENTER):

[TABLE="width: 711"]
<colgroup><col width="711"></colgroup><tbody>[TR]
   [TD="width: 711"]IFERROR(INDEX($B$3:$B$49,SMALL(IF($A$3:$A$49=C$2,ROW($B$3:$B$49)-ROW($B$3)+1),ROWS($C$3:C3))),"")[/TD]
 [/TR]
</tbody>[/TABLE]

It looks like you could just use this non-array formula:

[TABLE="width: 711"]
<colgroup><col width="711"></colgroup><tbody>[TR]
   [TD="width: 711"]=IF($A3=C$2,$B3,"")
[/TD]
 [/TR]
</tbody>[/TABLE]