|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 5th, 2004, 03:10 PM
|
|||
|
|||
Rank column with changing # of rows
Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws everything off. Please help :-)
|
|
#2
July 6th, 2004, 06:44 PM
|
|||
|
|||
|
Rank column with changing # of rows
To modify the formula, you need to tell us what you want to happen to the
formula when you add or delete rows. On Mon, 5 Jul 2004 07:10:01 -0700, Amy wrote: Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws everything off. Please help :-)
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Eliminating duplicate records in consecutive rows of a column | Larry | Worksheet Functions | 1 | June 26th, 2004 01:42 AM |
| Eliminating duplicate records in consecutive rows of a column | Larry | General Discussion | 1 | June 26th, 2004 01:28 AM |
| Deleting rows with no data using Auto Filter and Helper column | John | Worksheet Functions | 1 | April 19th, 2004 06:52 AM |
| Changing rows and columns size across all workbooks | Stephanie R | Worksheet Functions | 1 | October 11th, 2003 05:57 PM |
Linear Mode
