I am tyring to take the RANK formula and apply it to a filtered list but when I filter the list down the rankings still apply for all of my records. Any one know a solution?
1) Filter your list
2) highlight the column you'd like to base your rankings on
3) Hit f5 -->special --> visible cells only
4) define this as a named range (easiest by clicking on the "name box" above A1 and typing in a name for this range)
5) rank the cells against the named range
Thank You fairwinds.....How about for <0 numbers in the list? This worked great on a column of positive numbers but I have another column I need to filter rank that has both positive and negative.
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.