Forum Discussion

Justin Kerslake's avatar
Justin Kerslake
Copper Contributor
Jan 18, 2017

Working with customer feedback data

Hi all, 

 

I have over 6000 rows of customer feedback in a spreadsheet from the first 6 months of the current FY. The data has columns that provide the date, case number and address details, amongst other things. I want to identify the addresses that have multiple feedback entries against them and I'm not sure the best way to go about it. I'd appriciate some help on this please.

 

Regards

 

Justin

BI & Data Analytics
Need Help

1 Reply

Sort By
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 18, 2017

    Hi Justin

     

    My first thought is to go for a Pivot Table

     

    You could then put Address in the row labels and Count of Address in the Values box,  you could then filter this by Value > 1

     

Resources