| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Varying left criteria based on 1st Letter....If Function?
Hello,
I am using Pivot Tables for Inventory purposes. I'd like to use a shortened description based on the first letter of the description. Can I use an If Statement? Such as if 1st letter of Description is M - use 1st Left 5 characters, if 1st letter of description is L - use 1st Left 8 characters? Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| How can I reference a cell as the criteria in a count if function. | Excel Discussion (Misc queries) | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
