#1
|
|||
|
|||
Formula for searching names in one go
Please help me out ...
here I am attaching snapshots of two excel sheets 1. has description 2. names of persons What I wanna do is that , I want to check the names of person are matching should indicate me in red or whatever color in different cell from description list. If name is already in the list of "names list" file matching from the list of "names description" file should show me the indication that name is already in the list. Thanks waiting for snappy response. |
#2
|
||||
|
||||
Try conditional format formula starting at A2 of KYC Info sheet:
=COUNTIF(Sheet1!A:A,"*"&A2&"*") |
#3
|
|||
|
|||
Thanks alot for this.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
Searching for string on a formula | AMD2800 | Excel | 1 | 12-17-2014 10:41 AM |
matching names in column A with names in column C | bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
Backwards Searching Using a Formula | OTPM | Excel | 5 | 05-17-2011 09:17 AM |