look up by multiple variables

[Jimbo]

I have 500 employees. I want to sort by state licensure and by hour
increments. Basically, I want to know by hour how many employees do
I have working in any given state.

How can I do this?

Thanks in advance.

 

[joel]

You need to create a new table with hours and state and then fill in th
table


Number of employee by Hour and State
NY NJ Cal
8:00 AM 6 3 3
9:00 AM 4 8 5
10:00 AM 3 9 10
11:00 AM 2 4 3
12:00 PM
1:00 PM
2:00 P