Dear excel gurus,
I am in need of some help. I have a column with numbers in it starting in B2 and ending at B7660.
I need a MULTIPLE IF statement that will allow me to identify what type of number it is, so for example;
If the first number begins with a
1 = Shop.Order
2 = Rwk.Order
4 = Purch. Order
5 = PM-Maint
3,6 = Plan.Order
So I i have the statement correct in column O, then it would look like this.
416115780 Purch. Order
Any help with this will be greatly appreciated.