chillijo
12-02-2010, 12:06 PM
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
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