Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for product based on criteria? | Excel Worksheet Functions | |||
Assigning a Value based on Results | Excel Worksheet Functions | |||
Executing a formula based on criteria being met | Excel Worksheet Functions | |||
conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
Need formula based on criteria. | New Users to Excel |