I have a column with a bunch of numbers in it, then i also have several cells with functions that use that data as precedents.
Every time I sort the data differently the functions become wrong because they take the value from the cell location rather then where the value is after the sort.
Example:
cell A1 = 4
cell A2 = 3
cell A3 = 1
cell A4 = 2
C1 =SUM(A1,A2) so the value that will return is 7, however if I was to sort column A smallest to largest we would see:
cell A1 = 1
cell A2 = 2
cell A3 = 3
cell A4 = 4
C1 will no longer return 7, it will now become 3. So in other words I want the function to return the same value. Is there a way to make it change automatically from =SUM(A1,A2) to =SUM(A4,A3) after the data is sorted??
Every time I sort the data differently the functions become wrong because they take the value from the cell location rather then where the value is after the sort.
Example:
cell A1 = 4
cell A2 = 3
cell A3 = 1
cell A4 = 2
C1 =SUM(A1,A2) so the value that will return is 7, however if I was to sort column A smallest to largest we would see:
cell A1 = 1
cell A2 = 2
cell A3 = 3
cell A4 = 4
C1 will no longer return 7, it will now become 3. So in other words I want the function to return the same value. Is there a way to make it change automatically from =SUM(A1,A2) to =SUM(A4,A3) after the data is sorted??