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