troubleshooting Question

How do I make my formula cells follow after a sort

Avatar of chris pike
chris pikeFlag for Canada asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution86 ViewsLast Modified:
Hi Experts,
I have a formula in a cell in a table but when I sort the formula is looking back at the previous cells still.
The cells d23 and m23 stay d and m even after the sort.
=DATEDIF($D$23,$M$23,"m")  it will stay in the correct column of course but will not follow the new row position.
This clip is after a sort by date...…
dynamic row not following formula
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros