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
- If statement to add values - Guide
- How to compare two columns and return values from the third ✓ - Excel Forum
- Based on the values in cells b77 b81 - Excel Forum
- Conversion of values already present in cells ✓ - Excel Forum
- Compare values in two columns and return the value from third ✓ - Excel 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