Forum Discussion
Excel IF and OR Formula Help
| Cust No | Division | Cust Name | Job Description | Influencer Name | Title | Address 1 | Address 2 | Address 3 |
| 43 | G | example 1 | sales | john doe | OWNER | example 1 | PO BOX 159 |
Cust No. is Column A and then consecutive letters from left to right thereafter.
sorry that didn't copy columns over:
Cust No. is Column A and then consecutive letters from left to right thereafter.It's also not an Excel spreadsheet, and, to the extent that it did contain information, it didn't contain any that illustrated what you're trying to resolve. I have no problem visualizing what columns and names and addresses look like. What I'd like to see is what you're actually working with.
As HansVogelaar has already said, if you really want to do exactly what you said in your first post, it's not a formula you need, but a VBA (Visual Basic) routine (or macro). I'm wanting to see what you're actually working with, the actual spreadsheet (or a mock-up, still in Excel but without the confidential info), WITH problem columns that need to be fixed, so as to determine whether a formula or two can do it.
Your choice.
