Formula or Macro? Help

[chillijo]

Hi all thanks in advance for the help!
Ok here's what I’m trying to do, as you can see by the attached files, there are 2 worksheets one labeled Mai n and one labeled Data. On the worksheet labeled Main, I’ve inserted formula in Net_Sat Score, Date, Manager, AGENTID, Survey count, Very satisfied, Satisfied, Neither satisfied nor dissatisfied, Dissatisfied, Very dissatisfied columns, to pull from the Data worksheet.
What I need to do is on the Data sheet, it be sorted by the “Agentid and Overall” columns, counting the overall data then deleting the duplicate agent id but counting its overall data. Included is a file showing what the finished worksheet looks like.
Not quite sure the best way to do what I’m asking “I’m a beginner”
Again thanks in advance
Joe B

[Sean.DiSanti]

Check out pivot tables. i think you'll like the outcome even better than your intended result

[chillijo]

The only ting with the pivot table is it wont calculate the percentage in the net_sat column for me.

[Sean.DiSanti]

add that field to your data prior to making the pivot table, then have that be one of the fields displayed?

[Bob Phillips]

Yes it can.

Add the field to the Values pane twice, and select the second and then right-click, Summarize Values By ...>More Options>Show Values By and in the dropdown select % of Grand Total

[chillijo]

Your Right it does work not quite what I wanted but it does work, Thanks all .
My next question is can I make it work with a formula like the ones I put on the main sheet, by putting a formula on the data sheet to count [FONT='Calibri','sans-serif']the Agentid and Overall columns, counting the overall data then deleting the duplicate agent id but counting its overall data. So what I have in the main sheet will pull from the data sheet.[/FONT]
[FONT='Calibri','sans-serif']Joe B[/FONT]