Forum Discussion
Summarize Counts in an Adjoining Column - Excel
Easy with a pivot table.
Select any cell within your table and choose Insert, Pivot table
Drag both Email and Manager name fields to the row area. The drag either of the two to the bottom-right area. See screen-shot:
Easy with a pivot table.
Select any cell within your table and choose Insert, Pivot table
Drag both Email and Manager name fields to the row area. The drag either of the two to the bottom-right area. See screen-shot:
Jan - thank you so much for the reply..... I did these steps as that is all that I could see to do....
Almost works but I am not getting the Count it appears >>
Just below Column heading "Count" I chose Insert and pivot table
Selected Table / Range is --- '90 Day all_phishing_activity_08'!$A$1:$I$656
Choose where you want the Pivot Table Report to be placed - Chose Existing Worksheet----- '90 Day all_phishing_activity_08'!$B$4- Actually I think I got it.... I had to drag the Count field down to the Values Box
THANKS JAN !!
PS - Any relation to Sasha Pietrse ?
