LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Tabulating a large list

So here is my problem. I am supposed to create a tabulated table comprising
multiple different criteria for multiple people. Here is an abbreviated
version of what I am working with:
Bob 1 Cars January
Bob 2 Trucks January
Bob 1 Cars February
Jack 2 Cars January
Jack 2 Trucks February
Jack 1 Cars February
Bob 4 Trucks February
Jack 5 Cars January

Trying to get it into this format:

Employee Month Cars Trucks
Bob January
Jack January
Bob February
Jack February

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tabulating interview questions MyMy Excel Worksheet Functions 1 April 24th 07 01:30 AM
Tabulating Multiple Surveys in Excel Chuck Excel Discussion (Misc queries) 0 March 28th 07 02:46 AM
Tabulating Multiple Surveys in Excel Gary''s Student Excel Discussion (Misc queries) 0 March 28th 07 01:50 AM
tabulating and analyzing survey data bob Excel Discussion (Misc queries) 1 February 1st 05 11:45 PM
Tabulating Survey Results Tabulatin Survey results Excel Discussion (Misc queries) 3 December 13th 04 09:56 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"