canadianbacon357
New Member
- Joined
- Oct 19, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Hello,
Apologies if this topic has already been answered; I searched and could not find a similar solution.
I have a large amount of data (222,000+ rows) which contain values that are a hyphenated string in each cell, stored as text. An example is shown below. Not all of the rows contain the same values - ranging from 001 to 999.
I would like to know what the best way is to find or filter these rows for a specific value, i.e. 385.
Not sure whether a =COUNTIF or =INDEX function would work here.
Thank you!
Apologies if this topic has already been answered; I searched and could not find a similar solution.
I have a large amount of data (222,000+ rows) which contain values that are a hyphenated string in each cell, stored as text. An example is shown below. Not all of the rows contain the same values - ranging from 001 to 999.
| 357-361 | 373-378 | 381-389 | 394-399 | 581-999 |
I would like to know what the best way is to find or filter these rows for a specific value, i.e. 385.
Not sure whether a =COUNTIF or =INDEX function would work here.
Thank you!
