Rank Question
Hi Skip,
Here's what I found in the archives.
Dan
__________________________________________________ __________
Newsgroups: microsoft.public.excel
From: Skip
Date: Fri, 13 Jun 2008 06:28:03 -0700 (PDT)
Local: Fri, Jun 13 2008 5:28 am
Subject: Using RANK Function
I need to rank 225 rows of data. Can I use the replace function so
D4:D229 appears in each cell? Thanks for the help.
Skip
Bernie Deitrick
Newsgroups: microsoft.public.excel
From: "Bernie Deitrick" <deitbe @ consumer dot org
Date: Fri, 13 Jun 2008 11:37:32 -0400
Local: Fri, Jun 13 2008 7:37 am
Subject: Using RANK Function
Skip,
Use $D$4:$D$229 as the range reference in your RANK function, and it
won't change when you copy the
formula.
HTH,
Bernie
MS Excel MVP
"Skip" wrote in message
news:4a482838-1cf3-419c-
|