column comparision counting.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that i need to compare columns.

in column a is the lookup value.
in column b,c and d is data to compare to column a

i want to compare column b to column a.

i want to compare b1 to a1 if they are the same then add 1
to the total
compare b2 to a2 and if they match then add 1 to the total
i want to then do this for column c compared to a then to
column d.
 
Hi
this works for me if the values in col. A+B are identical. You may post
an example of your data (plain text please - no attachment) and explain
your expected result
 
sample data
2 1 2 1 2
2 2 1 2 2
1 1 1 1 2
2 2 2 2 1
1 2 2 2 1
1 2 2 2 2
2 2 2 2 1
1 1 1 1 1
2 1 1 1 2
1 1 1 1 1
2 2 2 2 2
1 1 1 1 1
1 2 2 2 2
1 1 1 1 1

compare column b to column a, then count how many match
excatly. in this example there are 9 matches. i'm able
to do the counting in a 2 step process. first step: =if
(b1=a1,1,0) 2nd step: sum of the results. i'd like to
try to do this in 1 step.
 
thanks,

The formula did work for me but i have another ?... in the
formula you have a double --, what does this represent, i
haven't seen something like this before? of course if i
had, i probably wouldn't be posting to the boards, but
would be responding ;)
 
Hi
this is an unary operator (double minus). It coerces the boolean values
to real numbers (TRUE=1, FALSE=0)
 
Back
Top