I have a formula that refers to one cell that has a fixed value in it. When I sort, the formula gets an error for the value in that cell. Is there a way to designate a fixed cell within a formula, so when sorting that specific cell is always referred to?
Bookmarks