Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If's conditions about matching
How can I code these if's conditions: 1) If the first letter of the statement is "A" or number "2" 2) If the second word of the statement is "join" or "joins" or "joined" 3) If there's a phrase (eg paid by cash) in the statement 4) Whether the phrase appears at the start, in the middle, or at the end of the statement The position of the phrase: Statement 1: {phrase}... ... [start] Statement 2: ...{phrase}... [middle] Statement 3: ... ...{phrase} [end] Thank you! -- Additional info about my computer: - Office XP - Windows XP Pro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Count matching cells | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |