Sort changing formulas
 

I have a range of cells that I am sorting based the cells in a particular
column which is =IF(B2=B3,FALSE,""). I want the formula to stay the same
"relative" to it's location (if that's the right way to say it). The B2=B3
part might change to B20=B27 or something like that - in the sense that it
doesn't keep it relative like how a macro can record. Any ideas?

--
David P.

Sort changing formulas
 

Starting with the formula:

=IF(B2=B3,FALSE,""),

copy this down the column. Then highlight the column and CTRL-H (Find
& Replace) with these settings:

Find What: B
Replace with: B$

Click Replace All. Then when you sort you should get the effect that
you are after.

Hope this helps.

Pete


On May 12, 10:13 pm, David P.
wrote:
I have a range of cells that I am sorting based the cells in a particular
column which is =IF(B2=B3,FALSE,""). I want the formula to stay the same
"relative" to it's location (if that's the right way to say it). The B2=B3
part might change to B20=B27 or something like that - in the sense that it
doesn't keep it relative like how a macro can record. Any ideas?

--
David P.

Sort changing formulas
 

Hi David P.,

If the formula is on Row 3 when entered:

=IF(OFFSET(B3,-1,0)=B3,False,"")

More information on OFFSET
http://www.mvps.org/dmcritchie/excel/offset.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David P." wrote in message ...
I have a range of cells that I am sorting based the cells in a particular
column which is =IF(B2=B3,FALSE,""). I want the formula to stay the same
"relative" to it's location (if that's the right way to say it). The B2=B3
part might change to B20=B27 or something like that - in the sense that it
doesn't keep it relative like how a macro can record. Any ideas?

--
David P.