hurricanedaphne
New Member
- Joined
- Nov 9, 2010
- Messages
- 8
I have a spreadsheet with over 50k rows of data that I need to assign to 6 different individuals based alphabetically on customer name. Currently I text-to-columns on the customer name to separate the first letter (assume to column B). My formula I use at that point is:
=IF(B2="A","Name1",IF(B2="B","Name2",IF(B2="C","Name3",))) etc, etc. til the entire alphabet is used.
I need to find an easier way! It does work just fine for what I need (especially since I copy the formula from another spreadsheet & just paste in) but other people are scared to use it so my boss asked me to come up with something else.
Is there a way to mark the If formula for 'begins with' text so I won't have to separate the name first? I am also willing to try a VBA macro, but I don't know how to do those (yet). I hate to ask someone to write the entire thing (unless you just happen to have exactly what I need already ). I need help to shorten this!
=IF(B2="A","Name1",IF(B2="B","Name2",IF(B2="C","Name3",))) etc, etc. til the entire alphabet is used.
I need to find an easier way! It does work just fine for what I need (especially since I copy the formula from another spreadsheet & just paste in) but other people are scared to use it so my boss asked me to come up with something else.
Is there a way to mark the If formula for 'begins with' text so I won't have to separate the name first? I am also willing to try a VBA macro, but I don't know how to do those (yet). I hate to ask someone to write the entire thing (unless you just happen to have exactly what I need already ). I need help to shorten this!