how to filter for begin of text string

T

ttp

I'm trying to create a simple filter to return a specific text statement if
the variable begins with 'CR'. EXCEL is returning false when I believe the
statement is true. Please help me see my error.

If(B1 = "CR*), then P = HQ else P = OC
 
S

Sean Timmons

IF(Left(B1,2)="CR", your results

Not sure what P is.. P1?

Then, P1="HQ",P1="OC")
 
R

Richard Schollar

Hi

Is this a formula question? If so then:

=IF(LEFT(B1,2)="CR","HQ","OC")

Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing a list of Records 3
VBA: How can I use a string variable as autofilter criteria? 4
Issue with Find 5
Counting the number of unique values in a filtered list 5
Refreshing filter on Subform in Access 2010 0
I have no clue about how to use vba 1
lastrow function help 6
Extract from the beginning of a text string 2

Top