Pivot Table Forum

[Spellbound]

Trying to make use and learn more about Pivot Tables but more for data manipulation than charting. I have noticed quite a few times in threads that a post suggests the use of a Pivot Table to solve a problem but best left answered by an expert on that subject.

So how about a forum dedicated to Pivot Tables, I will be interested to see how many others feel the same.

If this means to many different forums, then why not amalgamate the Excel General and the Excel Miscellaneous forums as these seem to overlap quite a bit. I have never been sure as to which one to use at times.

spellbound

[shg]

We're talking about reorganizing the forums now, and one for pivot tables specifically is being considered. And I agree that General and Miscellaneous are indistinguishable.

Thanks for the suggestion.

[Harmender]

I have details of employees around 100 for their status on 50 questions in column , I want to analyze the data in pivot candidate wise and question wise( how many candidates failed in Q1) (Experience wise failure status) . I am bit confuse. Can anyone help me out.


Name Experience Q1 Q2 Q3 Q4
A 1 Fail Pass Fail Pass
B 2 Pass Fail Pass Fail
C 3 Fail Pass Pass Fail
D 1 Pass Fail Pass Fail
E 5 Pass Fail Fail

Thanks
Harmender

[AliGW]

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.