Recent Changes - Search:

PmWiki

pmwiki.org

edit SideBar

MATCH

=IF(ISNA(MATCH(A2,$C$2:$C$140,0)),"",INDEX($C$2:$C$140,MATCH(A2,$C$2:$C$140,0)))

=IF(ISNA(MATCH(A2,$C$2:$C$140,0)),"",INDEX($C$2:$C$140,MATCH(A2,$C$2:$C$140,0)))

two columns , A and C, with similar text. Finding which match and which do not

Edit - History - Print - Recent Changes - Search
Page last modified on April 25, 2023, at 08:38 PM