Formula needed for report

[Gunther Chiskey]

Good Morning to all,

I am hoping somone can help me on the below issue as I am completely stuck as to what to do. I know what is needed but not sure how to get it into a formula.

I have a monthly report which I have attached a sample (real names etc changed). What I need to do:

. column A shows the ID number of the case - this can be multiple lines long. If one person ((Column B) worked on a case there will be one entry for the ID if 10 people worked on the same case there will be 10 entries - 1 per person
. Column D shows how many relevant actions the person in column B made on that case
. Column E shows the customers feedback score for the case ID

What I need is a function or button or somehting (sorry I'm not sure of the best solution) to look at column A and pick out each case ID and then feedback which person in column B made the most actions, and also to show the customer feedback score. So in the attached file for example the first 7 lines are for the same case. If we then look at column D we can see dave and gunther both had the same amount of actions on that case so the output should be : Case Id, name/names of the highest acts and the satisfaction score.

Any idea ?

Kind Regards

Gunther

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[amy_d2]

Hi Gunther

pls check sheet 2 if that is your desire result, i have used pivot table

if it is suitable for you then to build this kinda table you can select your data go to insert pivot table then

Row label drag Case ID, act value, full name & in value you can drag Overall satisfaction with resolution/handling

Thanks,
A

[amy_d2]

opps i did not seen administrators post ,.......sorry