On the attached spreadsheet, I have a list of vehicles and dates, with the vehicles marked on each day that it was used.
It looks like this:
................Truck 1.......Truck 2.......Truck 3
1/1/10...........1................1.......................
1/2/10...........1..................................1.....
1/3/10...........1................1................1.....
On the second tab, I was hoping that I could have the vehicles listed across the top, and then, underneath, display a list of all of the dates that that vehicle was used. Similar to this:
Truck 1..........Truck 2..........Truck 3
1/1/10............1/1/10............1/2/10
1/2/10............1/3/10............1/3/10
1/3/10...........................................
I will then use "countdiff" to find the total amount of unique values.
Thanks in advance for the help,
- Stu
Bookmarks