Comparing values

Closed

rosh - Jul 6, 2009 at 02:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:38 PM

Hello,
I have two columns with wth values i want to compare the two values each every value of the column 1 with the values in column two if the value is available i want it to be put on th3 third column.

Comparing values
Vba colorindex values - Guide
Based on the values in cells b77 b81 ✓ - Excel Forum
Comparing 2 excel sheets - Guide
How to copy values from one sheet to another in excel - Guide
Insert picture in Excel macro which takes the file name refrence - Excel Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 6, 2009 at 09:38 PM

use some modification of this formula

=IF(ISNUMBER(MATCH(B2,C:C,0)),B2,"")
and copy it down

in this case the words are in column B and C

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!