Board index MS EXCEL

comparing matching same values in two different columns

comparing matching same values in two different columns

Post by Frank Kabe » Thu, 12 Aug 2004 05:27:18


Hi
one way (without using VBA). Enter the following in column C (cell C1:)
=IF(ISNA(MATCH(A1,$B$1:$B$100,0)),"",A1)
and copy this down.

Afterwards select column C, copy this column and insert it with 'Edit -
Paste Special - Values'. Now you can delete the old column B
 
 
 
Top

1. How to compare two different columns in two different rows.

2. How do i compare values from two sheet and copy & paste if values match?


1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to a "=" value on sheet 2 in Row "A" (Row A2:A6), and then Cells (J & x : AH & x) need to be copied from sheet 2 and pasted in sheet 1 row of the value matched Cells (J & x : AH & x)

Question

How do i compare values from two sheet and copy and paste if values match

Thanks
Rozb

3. comparing two columns and extracting what is different into a third column

4. If two criteria match then sum matching values in another column

5. Compare Column values with column names in different tables

6. HELP: Compare Column values with column names in different tables

7. COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN

8. Comparing two values in different worksheets and extracting value

9. Comparing values in two columns to generate result in a third column

10. how to compare/sort values in two columns of two worksheets?

11. Display maximum value of matching values in a different column

12. Return Values in Same Row, Different Column That Match Cell Value

13. Matching values from two columns and making a third column with th

14. Matching values from two columns and making a third column wit

All times are UTC
Board index