sort button issue

[step_one]

Hello

I have attached a sample workbook.

for some odd reason, and dont know why at all, 3 of my sort buttons are not sorting correctly. they are sorting with the header field, and started happening randomly?

i have highlighted them in "red"...all other sort buttons function correctly, except for

1) SE
2) branch
3) overall

can someone pls help! been stuck at this for a couple hrs, thx you!

[Sadath31]

your Current.region code take one row above the table, that is the reason

try this

Please Login or Register  to view this content.

[step_one]

omg thx you so much! life saver