How to Sort Data in Excel Without Messing Up Formulas

This video will show you how you to fix a common problem that happens in Excel when your formulas aren't referencing the correct cells after sorting your data.

[feliciadaniel]

THANK YOU SO MUCH! You truly have no idea how helpful this was. I just go super lucky I ended up clicking this video as it solved my problem exactly. I was scouring the internet trying to figure this out and finally found this video. Thank you, thank you, thank you, thank you!!!!

[taurus]

Helpful to know, but how do you get around that? What if you still want to manipulate the filters while also ensuring the formula remains consistent, regardless of changing the filter on another sheet?

[bcr.]

Straight to the point and nailed the solution! Thank you so much for posting this!

[sachimo]

you are the only person on the internet who has helped me thank you there is not a single easily accessible article of youtube video that explains this for beginners. THANK YOU!

[shannont]

This is great if the reference is on the same sheet, but what about if it is on a different sheet?

[NaguiSalsa]

Thank you so much! This solved my problem with my worksheet! But this is interesting. Because when you are creating formula by clicking cells, it automatically add the sheet name. Why does it add the sheet name if the cell is referencing the cell in the same worksheet? (FYI: I also reference data from another worksheet in the same formula)

[myrandameans]

This also happens if you create a table and include a cell that is outside the table but still within the same sheet. For me, it's looking like I have to create a new column in the table with the cells I want to include in my formula. It's a bummer. Let me know if you know of tricks that can help me.

[wesleyg]

Works like a charm! In short: If your formula includes the name of the tab that you are in, remove that reference in your formula.

[guy-stephaneamanzourethyao]

Thank you so much, not sure why i never realized it until now. You’re a life saver

[dianapowell]

thank you!! I couldn't figure out why this kept happening!!

[AmbutuMalone]

Extremely helpful. I was spending so much time readjusting the cells.

[CheLudo]

You sir are a legend thank you for saving me hours of google searching with this fairly simply trick

[guilhermetosinibraz]

This video was extremely helpful for me! Thank you so much!

[NicoleVanNatta]

If I have cells that reference other cells within the same sheet, but not in the same row, it messes up the formulas when I sort. How do I fix that?

[parkelevators]

I was ready to pull my hair out! Thank you for this simple but elusive solution!!!

[VamsiKrishna-phip]

i got the solution after years.. thanks guru

[washsharecarpetwash]

you solved my trouble from first two minutes

[DustyKiaski]

Thank you - this helped and fixed my issue!

[nipun]

exactly what i was looking for, thank you :)

[meisammogharehabed]

This video was extremely helpful for me, thanks