Results 1 to 6 of 6

Rank top 3 Products with highest satisfaction rating

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    Sao Paulo
    MS-Off Ver
    2016 (macOS)
    Posts
    12

    Exclamation Rank top 3 Products with highest satisfaction rating

    Hi,

    1. So, how to obtain the top 3 products with highest satisfaction rate? Is there a way to do it using pivot table (preferably with slicers) in an automated fashion?
    2. What would be the best way to sort it out the top 3 products without using filters? Besides the ‘affected product’ column, there’s another column with ‘0’ for dissatisfied rating and ‘1’ for satisfied rating. Which I tend to use as way to calculate the satisfaction % (positive surveys ÷ total surveys).

    I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report.

    Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets, computers, smart keyboards, all the way to cloud services and accounts.

    I was thinking of SUMPRODUCT to conditional ranking (couldn’t do it), or categorize the products and make a graph out of it, but I’m really lost on this one.

    I really need some help here ):
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Customer Satisfaction Survey Rating calculation
    By anilgopi99i in forum Excel General
    Replies: 2
    Last Post: 03-17-2021, 12:17 PM
  2. [SOLVED] Filtering the highest revision number for a individual products
    By bob.m in forum Excel General
    Replies: 8
    Last Post: 12-16-2019, 03:28 AM
  3. Replies: 3
    Last Post: 05-27-2019, 06:19 AM
  4. Replies: 2
    Last Post: 09-10-2018, 04:00 AM
  5. Replies: 3
    Last Post: 11-22-2013, 06:06 PM
  6. [SOLVED] A formula to rank the Top 10 products based on month selection
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 12:54 PM
  7. [SOLVED] Rank where lowest value is highest rank
    By mile3024 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2005, 07:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1