Oct 31 2021 08:53 PM
Worksheet was a table which was then converted to back to range. On conversion the formula's don't correctly stay with the relative row of data.
DATA DIRECTLY AFTER CONVERTING BACK TO RANGE
DATA AFTER SORTING
Any suggestions on how to resolve this issue
Oct 31 2021 09:49 PM
Solution
To fix this, go to the first cell with the formula in column Q and double click the fill handle (bottom right corner of the cell), which will fill down and overwrite the existing formulas down the rows and fix the relative references.
Oct 31 2021 10:50 PM
@Subodh_Tiwari_sktneer thanks for your quick response. have done your recommended action and can confirm that this has been able to fix the issue i was experiencing
Nov 01 2021 08:44 PM
You're welcome @skeeta56! Glad it resolved the issue.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.
Oct 31 2021 09:49 PM
Solution
To fix this, go to the first cell with the formula in column Q and double click the fill handle (bottom right corner of the cell), which will fill down and overwrite the existing formulas down the rows and fix the relative references.