Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I'm trying to find a way of automatically interrogating info from a table with a series of data in columns, including MONTH and TEAM. The table records site visits, with each line recording a separate visit. In particular, I want to be able to automatically calculate the number of visits achieved by each team per month. At the moment, I can't figure out how to get it to look at all the variables. A colleague suggested a pivot table, but I can't make that work either. Please help! Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summarising data into a table | Excel Worksheet Functions | |||
How do I add multiple variables to a pivot table simulaneously | Excel Discussion (Misc queries) | |||
How come I only get 4 variables shown on my data table in chart? | Excel Worksheet Functions | |||
Transfer a list of info dependent upon variables | Excel Discussion (Misc queries) | |||
Summarising table entries | Excel Worksheet Functions |