LinkBack URL
About LinkBacks
C2 =if(isna(match(b2,A2:A19,0)),"",b2)
copy down
Conditional formatting for column C with Formula IS
=NOT(ISNA(MATCH(B1,$A$1:$A$19,0)))
C2 =if(isna(match(b2,A2:A19,0)),"",b2)
copy down
Conditional formatting for column C with Formula IS
=NOT(ISNA(MATCH(B1,$A$1:$A$19,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks