Hello People, help
I think I need to do a lookup for the following problem. I have inserted link to the sample table (image of the table) here:
https://docs.google.com/leaf?id=0BwU...iYTFi&hl=en_US
On my current table , column A is the truck numbers and column B is days of the week on which the truck leaves the warehouse.
There are 7 characters representing days of the week on which the truck leaves. First digit is Sunday and 7th digit is Saturday.
"Y" means the truck moves on that day, "N" means the truck doesn not move on that day.
According to the table column B3 indicates that the truck only leaves on days 3 and 4 of the week (these are Tuesday and Wednesday). It does not move on days with "N".
"N" means the truck does not move on that day of the week. Column B4 indicates that the truck KG776 does not move on Sunday, Monday and Saturday. BUT the truck moves on Tuesday, Wednesday, Thursday and Friday.
I have over 20000 records. I need to have a formula (or macro) that will convert column B to look like column C.
Thank you
Bookmarks