SOLVED

Excel, Table converted to Range, formula's don't work correctly

New Contributor

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

skeeta56_0-1635738518074.png

 

DATA AFTER SORTING 

skeeta56_1-1635738664664.png

 

Any suggestions on how to resolve this issue

3 Replies
best response confirmed by skeeta56 (New Contributor)
Solution

@skeeta56 

 

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.