Home |
Search |
Today's Posts |
#1
|
|||
|
|||
advanced filtering in XLS
Hi all,
i'm stuck in creating a report/pivot table. I do not know how to find info on the net since it is hard to explain for a database-newbie. But i think it is not that difficult to create it. But I do not know how to do it in xls and am unexperienced in Access. Here we go: i want to have a report where I have all owners of CD1 CD2 and CD3, their name and then all other CDs they own. I have a list with all names mentioned multiple times in column A and the CD title they own in column B. the pivot tablle should look like : column 1 : the filter on the eg 5 CD titles. comlumn 2 : the name of the owner per CD title column 3 : all CDs this person posesses (including the one mentioned in column 1). The tricky part is column 3 : filter the name of the owner on CD in column1 but show all CDs of the owner which owns the CD in column 1. Anyone can help? Tina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Auto Filtering | Excel Worksheet Functions | |||
Advanced filtering in Excel to find records ending in xxx? | Excel Discussion (Misc queries) | |||
Advanced Filtering | Excel Worksheet Functions | |||
Advanced Filtering | Excel Worksheet Functions | |||
extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions |