Thread: [Solved] Need help with sorting a column by most common to least common
View Single Post
 
Old 12-06-2011, 12:49 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
The $ signs in cell references make that part of the reference absolute

F I if you drag a formula across containing $F3, the $F part will not change, while the row part might depending on how you drag.

See " absolute and relative references " in XL Help - F1
Reply With Quote