miKbagio0Kmrsc7ho miKbagio0Kmrsc7ho
  • 20-02-2017
  • Computers and Technology
contestada

How to compare two columns in excel for matches and differences?

Respuesta :

f123f f123f
  • 28-02-2017
If columns A and B has equal length you can use simply formula =A1=B1 for each row. i.e 
=A1=B1  for first row
=A1=B1  for second row etc

Formula returns TRUE if values are equal or FALSE if they are not equal 
Answer Link

Otras preguntas

A 0.050-kg lump of clay moving horizontally at 12 m/s strikes and sticks to a stationary 0.15-kg cart that can move on a frictionless air track. Determine the s
Active verbs meaning?
g Use the properties of the natural logarithm to rewrite each logarithmic expression as an expression with a single logarithm. a . ln ( x + 5 ) − ln ( x − 5 ) =
What is enriched food?
Helllllllllllllllllllpppppppppppppppppppppp
In proof testing of circuit boards, the probability that any particular diode will fail is 0.01. Suppose a circuit board contains 200 diodes. (a) How many diode
Neeed Helpp ASAP..!!!!
If G is an abelian group and phi: G rightarrow G' is a homomorphism of G onto G', prove that G' is abelian.
Solve the following equations: (a) x^11=13 mod 35 (b) x^5=3 mod 64
A force of 4 N will stretch a rubber band 0.04m. Assuming that Hooke's Law applies, how far will an 8-N force stretch the rubber band? How much work does it tak