Formulas Returning Wrong Values

[CARBOB]

Will someone please tell me why the formulas in G:K are returning wrong values. They are suppose to count how many of the values in B:F repeat. I think it may be a format problem, but can't find it.

Book1
	A	B	C	D	E	F	G	H	I	J	K
14							1	2	3	4	5
15	12/30/16	03	14	17	25	36	1	1	1	1	1
16	12/29/16	03	05	13	23	36	1	1	1	1	1
17	12/28/16	07	14	22	34	35	1	1	1	1	1
18	12/27/16	05	09	13	15	17	1	1	1	1	1
19	12/26/16	13	26	30	33	36	1	1	1	1	1
LAST DIGIT (2)

 

[AliGW]

Well, without seeing the formulae, I'm not sure we can tell! What are your expected results?

 

[CARBOB]

Well, without seeing the formulae, I'm not sure we can tell! What are your expected results?

The formulas are not showing for some reason, don't understand why not.

starting in G15
=SUMPRODUCT(IF(COUNTIF(OFFSET($B15,1,0,G$14,5),$B15:$F15)<COUNTIF($B15:$F15,$B15:$F15),COUNTIF(OFFSET($B15,1,0,G$14,5),$B15:$F15)/COUNTIF($B15:$F15,$B15:$F15),1))

1 2 3 4 5
12/30/16 03 14 17 25 36 1 1 1 1 1
12/29/16 03 05 13 23 36 1 1 1 1 1
12/28/16 07 14 22 34 35 1 1 1 1 1
12/27/16 05 09 13 15 17 1 1 1 1 1
12/26/16 13 26 30 33 36 1 1 1 1 1

 

[AliGW]

Thanks. What are your expected results? The formula seems incomplete - is there something missing at the end?

 

[MARK858]

ADVERTISEMENT

@AliGW the complete formula the OP posted is...

=SUMPRODUCT(IF(COUNTIF(OFFSET($B15,1,0,G$14,5),$B15:$F15)<COUNTIF($B15:$F15,$B15:$F15),COUNTIF(OFFSET($B15,1,0,G$14,5),$B15:$F15)/COUNTIF($B15:$F15,$B15:$F15),1))

 

[CARBOB]

I installed the HTML MAKER as an add-in, checked default and show formulas,is that right or wrong?

 

[AliGW]

ADVERTISEMENT

Thanks, Mark, but how do you know that?

 

[AliGW]

I installed the HTML MAKER as an add-in, checked default and show formulas,is that right or wrong?

I use the ForumTools add-in - link in my sig line.

 

[MARK858]

Thanks, Mark, but how do you know that?

Click reply with quote and you can normally see the full formula when Vbulletin is treating the < as a Html tag.

 

[AliGW]

Oooh, nice trick - thanks for that!

Doesn't work here in Firefox: I just get an empty message box.