HemlockPrinters
asked on
excel fomula
I need help to write the formular for ship type column.
The excel file has two columns, if the column shipper value doesn't begin with 'C-', or ' F-' or 'S-', then ship type column should be unknown, otherwise will return the first letter of Shipper column.
SHIPPER SHIP TYPE
PAT unknown
C-TH C
F-KC F
S-DB S
........
.......
thanks,
The excel file has two columns, if the column shipper value doesn't begin with 'C-', or ' F-' or 'S-', then ship type column should be unknown, otherwise will return the first letter of Shipper column.
SHIPPER SHIP TYPE
PAT unknown
C-TH C
F-KC F
S-DB S
........
.......
thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"Name that tune!"
Go play with Access. We're busy here.
BarryCade
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hey Kevin, just bought your book with Jelen/Umlas, to give to my sister in-law... hopefully it'll get her off my back for a while ;)
Not Umlas, Urtis.
ooops... :)
=IF(OR(LEFT(A2,2)="C-",LEF
Kevin