Can anyone tell me why the formula would reference row 509 instead of row 2 after I just sorted column K? It does it ALLLLLLL the time I fix it, save it, open it and it's fine until I sort anything.
Can anyone tell me why the formula would reference row 509 instead of row 2 after I just sorted column K? It does it ALLLLLLL the time I fix it, save it, open it and it's fine until I sort anything.
OMG!!!!!!!!!! I figured it out!!! All the formulas that I was having issues with where it would reference the wrong row after sorting had the tabs title in the formula. So as I was making the formula and going back and forth from tabs it would reference the name of "that" tab that would keep changing. I deleted the tab reference so it just referenced the cell and tested it and thus far it's been working!!! I can't believe I finally figured it out... been starring at this dang thing forever!
Glad you were able to get it figured out.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks