| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need Assistance: Average/Remove Duplicates
I've got quite a little puzzle and I'm just too inexperienced to figure this
out. I have 4 columns of data: Date-Agent-Score-Comment. An agent's name shows up multiple times within the "Agent" column. I need to move the Agent column to a new sheet while removing the duplicate listings and average each agent's average score next to their names. Also, will the data output be compatible with that nifty Autofilter feature? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to indentify duplicates in a "Self Populating" field? | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
| Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
| removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
Threaded Mode
