Microsoft Office Forums - View Single Post - Formula for searching names in one go

Thread: Formula for searching names in one go

View Single Post

Old

04-23-2018, 05:35 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC 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