Formula for searching names in one go

		Microsoft Office Forums > Microsoft Excel > Excel
Formula for searching names in one go

04-23-2018, 05:35 AM

NBVC

Windows 10 Formula for searching names in one go

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

=COUNTIF(Sheet1!A:A,"*"&A2&"*")

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 PM.