SOLVED

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

Copper 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 (Copper 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.

1 best response

Accepted Solutions
best response confirmed by skeeta56 (Copper 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.

View solution in original post