Excel Sorting Breaks Formulas

G

GreenWoman

My spreadsheet has a number of formulas (IF, and IF with embedded AND
formulas) that refer to cells in the same row. When I sort the rows, some
(but not all) of the formulas look at cells in the correct column, but in the
wrong row. To correct this, I have to go to the top row, check all the
formulas, and "fill down" to reset the formulas below to look at their proper
references.
 
S

Sam Wilson

Are the formulas anchored ie =A$1? If you have those rather than =A1 style
formulas then they won't change when sorted.

Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mid column sum formulas with varied ranges to sum 17
Insert Row also adds formulas and moves cursor 2
Formulas Mess Up on Insert Row 1
Formulas stopped working 1
Excel Allowing users to add rows in protected excel table 2
Column number of last column that returns value ignore formulas 8
Moving Formulas when Sorting 2
TABLE ROW SORT ERROR? 1

Top