PDA

View Full Version : Summarizing Data from a Table



tjtsantos
10-31-2008, 12:46 AM
Hello Experts,

I may need some help again.

I have a sample excel file attached. I am trying to output a summarized table like in the "Summary" tab. The data came from the "Data" tab. The drop-down list I used can be found at the "Category" tab.

In the "Summary" tab, what I am trying to output is the list of Level matching the category I selected.

If this can be done using Pivotable it will be of great help. However, I am not that too familiar with using the Pivotable.

Thank you in advance.

Tony

tjtsantos
11-03-2008, 04:46 AM
I found a work around, by using transpose, I was able to get my table results. Thanks and case close. :)

RonMcK
11-03-2008, 07:16 AM
Please mark issue solved. Click Thread Tools, check Solved.

Thanks,