Forum Discussion
Solved
Summarize Counts in an Adjoining Column - Excel
Hello, Thank you if you're reading this. I have a number of users in a column (array) called EMail. Sometimes they are in the column multiple times. I need to count the total occurrences for ea...
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 ?
THANKS JAN !!
PS - Any relation to Sasha Pietrse ?