Assigning value based on criteria in Formula
 

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?
--
Hile

Assigning value based on criteria in Formula
 

Assuming *all* entries are in this format:

(Biff)Name
(1)Name

=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")

--
Biff
Microsoft Excel MVP


"Hile" wrote in message
...
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?
--
Hile

Assigning value based on criteria in Formula
 

Thank you so much. You know I know all those darn functions too, I guess
today is not a "thinking" day for me... duh!

:-)
--
Hile


"T. Valko" wrote:

Assuming *all* entries are in this format:

(Biff)Name
(1)Name

=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")

--
Biff
Microsoft Excel MVP


"Hile" wrote in message
...
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?
--
Hile

Assigning value based on criteria in Formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hile" wrote in message
...
Thank you so much. You know I know all those darn functions too, I guess
today is not a "thinking" day for me... duh!

:-)
--
Hile


"T. Valko" wrote:

Assuming *all* entries are in this format:

(Biff)Name
(1)Name

=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")

--
Biff
Microsoft Excel MVP


"Hile" wrote in message
...
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?
--
Hile