How to "fix" a range so that copy/paste doesn't increment it

by Thufir   Last Updated February 16, 2018 18:03 PM

When filling this formula down a column:

=if(OR(H5>=LARGE(UNIQUE(H1:H11),1), H5>=LARGE(UNIQUE(H1:H11),2)), "top", "")

When I copy/paste it from row 5 to row 6 I get:

=if(OR(H6>=LARGE(UNIQUE(H2:H12),1), H6>=LARGE(UNIQUE(H2:H12),2)), "top", "")

H6 is correct, but, for range H2:H12 should stay as H1:H11. The copy/paste is anticipating and changing the formula. Normally that works fine.

How can I alter the formula, or alter the copy/paste process, so that the comparison range is fixed?

Or, perhaps, define the comparison range somehow? The caveat being that I don't want delve too deeply into formulas. Not so much for the KISS principle but in consideration of the learning curve.



Answers 1


Use $ sign to lock range.

$H$1
I'-'I
I'-'I
February 16, 2018 17:26 PM

Related Questions


Disable Drag & Drop Google Sheets

Updated November 12, 2017 14:03 PM



Google Spreadsheet Paste

Updated July 10, 2015 13:01 PM