Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2018, 09:34 AM
SilverChat SilverChat is offline Formula for searching names in one go Windows 8 Formula for searching names in one go Office 2013
Novice
Formula for searching names in one go
 
Join Date: Feb 2015
Posts: 3
SilverChat is on a distinguished road
Default 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.



Reply With Quote
  #2  
Old 04-23-2018, 05:35 AM
NBVC's Avatar
NBVC NBVC is offline Formula for searching names in one go Windows 10 Formula for searching names in one go Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Try conditional format formula starting at A2 of KYC Info sheet:

=COUNTIF(Sheet1!A:A,"*"&A2&"*")
Reply With Quote
  #3  
Old 05-07-2018, 06:11 PM
SilverChat SilverChat is offline Formula for searching names in one go Windows 8 Formula for searching names in one go Office 2013
Novice
Formula for searching names in one go
 
Join Date: Feb 2015
Posts: 3
SilverChat is on a distinguished road
Default

Thanks alot for this.
Reply With Quote
Reply



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
Formula for searching names in one go 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
Formula for searching names in one go Backwards Searching Using a Formula OTPM Excel 5 05-17-2011 09:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft