| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Report on data in rows & columns
Hello,
I have data in a spreadsheet with column and row headings, then data at the intersecting cells. The columns represent days of the week, the rows represenet workstations, and the data consists of the names of people using the workstations. I would like to take this data over several weeks and know how many times person 1 worked at station 1, station 2, and so on for all people and all stations. Is this possible with a pivot table or some other data analysis tool within Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
| Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) | |||
| =(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
Threaded Mode
