Slicer Problem with Rank Function

zarealshook

New Member
Joined
May 26, 2014
Messages
14
Office Version
  1. 2016
Platform
  1. Windows
Hi Everyone,

I am working on a practice file with help of a video explaining every step to create a dashboard file. Everything went fine and clearly understood until I came to the Rank function to get the top rank of the products. The function worked fine but when I click on any slicer to test it, the "Rank" function returns "#VALUE" as you can see from the attached file.

I am unable to figure out what might have gone wrong here. Any help is really appreciated.

Attached you can find the file I am working on for your easy reference.

Regards,

Zare
 

Attachments

  • SCREEN BEFORE SLICER IS CLICKED.JPG
    SCREEN BEFORE SLICER IS CLICKED.JPG
    128.8 KB · Views: 18
  • SCREEN AFTER SLICER IS CLICKED.JPG
    SCREEN AFTER SLICER IS CLICKED.JPG
    144.6 KB · Views: 18

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hello.
Can you show Column Y in this? Your ranking formula is pointing to that column, but can't see what is happening there in the provided screenshots.
 
Upvote 0
Hello.
Can you show Column Y in this? Your ranking formula is pointing to that column, but can't see what is happening there in the provided screenshots.
Hi Johnny,

Thanks for passing by. I thought no one would respond to my inquiry, though! ;)

I am attaching herewith a screenshot of Column "Y" for your easy reference.

Hope I can get this fixed the soonest possible.

Regards,

Zare
 

Attachments

  • COLUMN Y.JPG
    COLUMN Y.JPG
    68.4 KB · Views: 7
Upvote 0
Rather than replicating your Pivot Table with Offset, are you able to create a ranking using the Pivot as your source? I tend to avoid Offset (just because it hasn't clicked in my head yet), but my guess would be that it doesn't like to play so nicely with how Pivot Table move.
 
Upvote 0
Rather than replicating your Pivot Table with Offset, are you able to create a ranking using the Pivot as your source? I tend to avoid Offset (just because it hasn't clicked in my head yet), but my guess would be that it doesn't like to play so nicely with how Pivot Table move.
Yes, Johnny, I am trying to use the ranking using the Pivot as my source. Any ideas on how to fix it with the offset? I just couldn't understand how she (in below link video) turned the rank function to read (=RANK(Y3#,Y3#)!!! Would you please be so kind to go over the below link video and advise how did she do it?


Thanks and best regards,

Zare
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top