Forum Discussion
Sangeeta Mudnal
Microsoft
MicrosoftWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
my excel in office home & student 2021- sorting function failed to link to same reference cell in formula.
normally the cell reference in the formula is absolute so no matter how we cut & paste or sort it will link to the same cell reference in the formula.
in this case after sorting no.
after sorting failed to link to cell reference in formula so formula changed thus value wrong.
can someone help me to fix this ??
Deleted
Please start a new discussion with your question.
- my excel in office home & student 2021- sorting function failed to link to same reference cell in formula.
normally the cell reference in the formula is absolute so no matter how we cut & paste or sort it will link to the same cell reference in the formula.
in this case after sorting no.
after sorting failed to link to cell reference in formula so formula changed thus value wrong.
can someone help me to fix this ??
