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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:38 PM
Related:
- Comparing values
- Vba colorindex values - Guide
- Comparing 2 excel sheets - Guide
- How to copy values from one sheet to another in excel - Guide
- Based on the values in cells b77 b81 - Excel Forum
- Comparing two excel files - Programming Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 6, 2009 at 09:38 PM
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
=IF(ISNUMBER(MATCH(B2,C:C,0)),B2,"")
and copy it down
in this case the words are in column B and C