Exact text search in a range of cells

Pecoflyer · #1 01-17-2023, 01:43 AM

Quote:

Originally Posted by Reyaaz

Thanks for your response, Pecoflyer.

In the attached example, the user types HR into the search box and a number of rows are pulled up which include HR.

A17 is fine as a search result, as it includes HR as a single word.

C15 and B16 are not, as they only include the word through, and not HR.

The info is gathered from the second sheet.

As I said, please post a sample sheet NO PICS !

OTOH your problem seems to be solved somewhere else . Please read A message to forum cross posters - Excelguru

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create a clickable text box to jump to a range of cells	sahara	Excel Programming	4	09-07-2017 10:56 AM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Search Range Within Cell or Cells	COEngineer	Excel	1	06-01-2016 11:50 AM
Search and reduce the range of a text selection	paik1002	Word VBA	1	12-17-2015 04:51 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM