Assigning value based on criteria in Formula

  • Thread starter Thread starter Hile
  • Start date Start date
H

Hile

I have a column that contains one of two types of values:
"(Name)Name"
"(Number)Name"

On another column I want to assign a tag to it "Manual" or "Auto". If the
cell starts with "(Name)..." I want it to say Auto else Manual. The
parenthesis is part of the value in the cell and I don't want to have to trim
or do any manual manipulation. I tried using the "T" function but it doesn't
work and I can't figure out the correct syntax using a wildcard to tell it if
the value starts with "(" and "text" assign Auto OR if the value starts with
"(" and "number" assign Manual.

Any suggestions?
 
Assuming *all* entries are in this format:

(Biff)Name
(1)Name

=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")
 
Thank you so much. You know I know all those darn functions too, I guess
today is not a "thinking" day for me... duh!

:-)
 
You must log in or register to reply here.

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

Can I get criteria from columns to populate down? 3
Sumproduct based on certain criteria 3
Assigning values 1
Assign numerical value to cell based on selection from drop-down m 1
Hide and Show Rows based on Cell Value 2
Assigning words to a number 1
Access Dcount (multiple criteria) 3
Assigning letter for numerical value 8

Back
Top