Xephon12
New member
- Joined
- Nov 14, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hi,
I'd be really grateful for any help on this. I've scratched my head for quite awhile on it...
I've got like 10000 entries of customers and each row entry has a free text box which occasionally states in some form "1" meaning their first transaction, I'm wanting to highlight just them rows to myself. It's muddied because the same box also occasionally contains the date like 11/7.
So, I'm wanting to search a column full of free text to find if it contains the number 1, and only one occurrence of the number 1 and to produce the text output "true" if so.
I've tried using different methods of finding the first occurance of a number, but don't know how to isolate and verify if that's the number 1.
Would be so grateful for any help in this matter to save me individually going through all 9000 entries...
Thanks!
I'd be really grateful for any help on this. I've scratched my head for quite awhile on it...
I've got like 10000 entries of customers and each row entry has a free text box which occasionally states in some form "1" meaning their first transaction, I'm wanting to highlight just them rows to myself. It's muddied because the same box also occasionally contains the date like 11/7.
So, I'm wanting to search a column full of free text to find if it contains the number 1, and only one occurrence of the number 1 and to produce the text output "true" if so.
I've tried using different methods of finding the first occurance of a number, but don't know how to isolate and verify if that's the number 1.
Would be so grateful for any help in this matter to save me individually going through all 9000 entries...
Thanks!