Microsoft Excel - Fill without changing range

Asked By Patrick Eisinger
12-Feb-09 09:37 AM

I am using an excel workbook to rank product sales uing this formula:

RANK(D3,D3:D46,0) +COUNTIF(D3:D3,D3)-1

The problem is when I fill it down the page the range advances adding to the data ranked. I need it to add the next cell but keep the range D3:D46

So if I drag this the next line would be

RANK(D4,D4:D47,0) +COUNTIF(D4:D4,D4)-1

Is there a way to add the next cell without changeing the range or changing each formula ?

Thanks

Patrick

use absolute cell address  use absolute cell address

12-Feb-09 05:35 PM
try this one
RANK(D3,D$3:D$46,0) +COUNTIF(D3:D3,D$3)-1

Any reference which has dollar sign to its left, will not change upon dragging. I am not sure with D3 in both formula. So check yourself, and put $ sign where you don;t want them to be changed.
Create New Account
help
How to delete a workbook in Microsoft Excel Excel Excel New Users Discussions Microsoft Excel (1) Workbook (1) VBA (1) You mean delete a file using excel? If yes, then you can
Secure OleDb Connection to a Microsoft Excel Workbook .NET Framework Good morning all, I want to password protect a Microsoft Excel Workbook containing all my reference tables for a program, so that I can place the workbook in a central location that is accessible by all, but so they can not wreck it. I am accessing the workbook via an OleDbConnection through the System.Data.OleDb framework. I have looked a few different
How can I email 2 pages from an Excel workbook. Excel I have a long running Excel workbook but only need to email 2 pages from it each month. How can I select the pages I want to send without sending the whole workbook every month Microsoft Excel 2003 Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Workbook (1) PetePages (1) Month (1
Microsoft Excel Excel I accidently saved a file to the wrong workbook in Excel and have lost the info in the workbook. Is there a way to unsave the data so that I can retrieve the correct data in the workbook? Excel Miscellaneous Discussions Microsoft Excel (1) Workbook (1) Ione (1) Unsave (1) Not without a backup
How do I delete a header in Microsoft Excel? Excel I would like to know how to delete a header in Microsoft Excel. Can you help? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2007 (1) Page (1) Workbook (1) SQRT (1) VBA (1) ShowFormula (1) Anne