Forum Discussion
Excel, Table converted to Range, formula's don't work correctly
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
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.
3 Replies
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.
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
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.
