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

The atomic number of nickel-60 is 28. How many neutrons does this isotope have?
Show a way to count from 170-410
Explain the central difference between main details and supporting details of a piece of writing.
If y varies directly as x, what is the value of y in these ordered pairs? (8, 4) and (4, y)
Which Italian Renaissance thinker believed that Italy needed strong, even ruthless, leaders and wrote The Prince to show how rulers can keep power?
What percent of 9.2 is 2.5?
Is sunlight an example of mechanical wave ?
the lowest common multiple of two numbers is 36, one number is 12, what might the other number be?
what is the first stage in the erosion process?
which is an example of an organism a. soil b. iceberg c. mold d. a molehill