# Searching a cell for unique values

#### abrig005

##### Board Regular
I'm using the following formula =IF(ISNUMBER(SEARCH("1a.",,\$AK2)), "Yes", "No")
To search with a cell for 1a.

The problem is I get a Yes in cells with 11a. or 111a.

What is the tick to find 1a. and 11a. and 111a. distinctly?

Thank you!

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
use EXACT("1a.",\$AK")
Code:
``=IF(EXACT("1a.",\$AK2),"yes","no")``

Last edited:
Thanks for the replies.
I realized that I didn't provide a key point.
The text may look like this: 1a.xxxxxxxxxxxxxxxxx;#11a.xxxxxxxxxxxxxxxxxx or 4a.xxxxxxxxxxxxxx;#14a.xxxxxxxxxxxxx
So EXACT doesn't yield and results and my original formulas produces too many results.

use EXACT("1a.",\$AK")
Code:
``=IF(EXACT("1a.",\$AK2),"yes","no")``

My mistake read that question wrong..

I realized that I didn't provide a key point.
The text may look like this: 1a.xxxxxxxxxxxxxxxxx;#11a.xxxxxxxxxxxxxxxxxx or 4a.xxxxxxxxxxxxxx;#14a.xxxxxxxxxxxxx

Hi,

What does the Number symbol ( # ) represent? An actual Number or literally the # symbol?

And, is the string you're looking for (i.e. 1a) Always at the beginning?

Last edited:
if you are looking to find the string to the left of the dot you could use:

Code:
``=[COLOR=#333333]IF(LEFT(\$AK2,SEARCH(".",\$AK2))="1a.", "Yes", "No")[/COLOR]``
Still, have a look at the code in the link I posted above.

Last edited:

Replies
1
Views
170
Replies
2
Views
321
Replies
3
Views
457
Replies
4
Views
590
Replies
1
Views
119

1,196,498
Messages
6,015,556
Members
441,900
Latest member
Inaschemitex2023

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back