-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
rank.eq
-
A
rank.eq with multiple if conditions
Hi, can anyone provide guidance/examples on rank.eq formula with multiple conditions? I am generating pivot table for Company A filtered by year, and I want to set up a linked table - table 2 (so row values change when my pivot filters change) to display rank.eq for each row value generated in...- adamelston
- Thread
- company rank.eq region table year
- Replies: 2
- Forum: Excel Questions
-
D
RANK.EQ Help with possible duplicate values
I have a bunch of formulas set up that bring in identifiers then a formula that brings in the percentage of the total value of a holding in column "F". In column "B" I was using the Rank.eq formula to rank the positions based on the value in column "F". The problem I ran into this month is that...- DRExcel515
- Thread
- column formula rank.eq ranking values
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy/paste values if the cell next to it is empty every month
- Started by Mortenhoey
- Replies: 38
Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to... -
VBA Worksheets and Ranges
- Started by p85ki
- Replies: 28
Hi all, I have spent hours yesterday reading and watching youtube around worksheets/ranges and loops and I keep getting stuck and need any... -
Run time error 450: Copying non zero values from non adjacent columns to another sheet (non adjacent columns)
- Started by JonathanSass
- Replies: 27
Hi all, I have tried to use the following code for my issue described in the header: [CODE=vba]Sub CopyDataToJournal() Dim erow As Long... -
VBA Code : Based on filter selected need to make changes in column
- Started by avicric
- Replies: 25
Hi All, Need your help with VBA code, I have to make changes to a column based on the filter selected in another column. So I have to put/select... -
How match duplicate entry
- Started by Pizzaman22
- Replies: 24
Hello, I was looking for help on how to match the following [I]A. B. C.[/I]... -
Show information Issue
- Started by JessyVal
- Replies: 23
Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call...
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.
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".
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.
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.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back