count of non matching values

[pala_jagadeesh]

HI 

I want count of mismatching values form below table,

like I want Total count of mismatch item  ie,( count of Orange,Banana,Grape because these three are not present in three columns)

Item	col1	col2	col3
Apple	Apple	Apple	Apple
Orange	Orange	-	Orange
Banana	-	-	Banana
Grape	-	-	Grape

output

count_of_mismatch

3

when I click on this count i want to show what are they

[sidhiq91]

@pala_jagadeesh  Could you please elaborate on your requirement, sorry I could not understand. It could be even better if you can provide some sample data and expected output. 

[pala_jagadeesh]

Hi @sidhiq91  I want count of items which are not present in three columns(it should be present in three columns, if not present , i want that items count)

if i click on that count ,its shows what are they

here Orange ,Banana and Grape are not present in three columns

only apple was present in three columns

So i want count of items (Orange ,Banana and Grape)  as output as

count_of_mismatch

3