Count IF formula?

[bflan0524]

hello
I don't know if this would be a count if formula, or something else, any ideas
I have 3 columns of data that have unique ID Codes
for example
Column A Row 1: ABC
Column B Row 1: BCD
Column C Row 1: ABC

I want to show the % of time that one officer code was the same, so for this example ABC was the officer code 67% of the time
thank you

 

[Caleeco]

for the first one it says I am missing a (....I put one in the end but it still didn't work

It is working on my end ( please see my updated post above). The website wont let me post formula properly as it thinks "<" is a HTML tag... :/
=INDEX($A1:$C1,1,IF(COUNTIF($A1:$C1,$A1)"<"COUNTIF($A1:$C1,$B1),IF(COUNTIF($A1:$C1,$A1)"<"COUNTIF($A1:$C1,$C1),3,2),1))

Remove the "" from the "<" above before pasting in excel.

Caleeco

 

[Caleeco]

in cell F1, place this formula to check number of changes:
=SUM(IF(A1"<>"B1,1,0),IF(B1"<>"C1,1,0))

Remove the "" from the equation before pasting into excel.

Cheers
Caleeco

 

[bflan0524]

It is working on my end ( please see my updated post above). The website wont let me post formula properly as it thinks "<" is a HTML tag... :/
=INDEX($A1:$C1,1,IF(COUNTIF($A1:$C1,$A1)"<"COUNTIF($A1:$C1,$B1),IF(COUNTIF($A1:$C1,$A1)"<"COUNTIF($A1:$C1,$C1),3,2),1))

Remove the "" from the "<" above before pasting in excel.

Caleeco

does this look right? it says I have to many arguments ( I had to add something different to column A that's why the columns look a little different)
=INDEX($B2:$D2,1,IF(COUNTIF($B2:$D2,$B2)<COUNTIF($B2:$D2,$C2)<COUNTIF($B2:$D2,$B2),3,2,),1))

 

[bflan0524]

I don't get it, the board keeps cutting my formula off, what a mess haha

 

[bflan0524]

in cell F1, place this formula to check number of changes:
=SUM(IF(A1"<>"B1,1,0),IF(B1"<>"C1,1,0))

Remove the "" from the equation before pasting into excel.

Cheers
Caleeco

so on this one if the example showed
column A BCV, column B BSE, Column C BSE its showing a return of 2, when I would like it to show 1 because it only changed unique officers once, does that make sense

 

[Caleeco]

so on this one if the example showed
column A BCV, column B BSE, Column C BSE its showing a return of 2, when I would like it to show 1 because it only changed unique officers once, does that make sense

Please check you formulas again. For the example you stated, I return a value of 1.

Cheers
Caleeco

 

[bflan0524]

I see what I did wrong, all set on everything
thanks again for your help, much appreciated

 

[Caleeco]

I see what I did wrong, all set on everything
thanks again for your help, much appreciated

Cool, glad you got it working
No Problem!

Caleeco