Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort two columns without changing the formatting? | Excel Worksheet Functions | |||
automatically sort a table after changing a cell | Excel Discussion (Misc queries) | |||
Changing the range of a table sort | New Users to Excel | |||
Preform alphabetical sort without formula in cell changing | Excel Discussion (Misc queries) | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) |