calendar of services I have a spreadsheet that looks like this: I need to have a

Question

calendar of services

I have a spreadsheet that looks like this:

I need to have a calendar that shows which services (along with customer) are ddue on which day (ie. second Tuesday) of whattever month. I don't care if I wind up with one calendar where I can define (via drop down list) the service and month and there are 31 columns that geet populated with jobs, orr if I wind up with 12 ddifferent sheeets that fill in wwith "customer" and I can look at just "CAB" services or just "JET" services.

I have about 10 different services, 500 customer jobs, and the frequencies vary from once

SERVICE CUSTOMER WEEK DAY MONTH1 MONTH2 MONTH3 MONTH4 CAB JOE first Monday January July JET SAM second Monday January April July October PUMP PETE first Wednesday January JET TOM third Tuesday All

Explanation / Answer

Hi,

Here's my suggestion.

1. Instead of All, have all 12 months listed inn 12 columns

2. Once that is done, convert the 12 month columns into a single column - the teechnique to do this is explained here - http://www.ashishmathur.com/converting-a--matrix-data-layout-to--a-tabular--layout/

Once data is converted into a taabular layout, you can apply filters easily.

Hope this helps!!

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.