Sorting Help

[vulcanfury]

Hi All,

I need a bit of help with regards to sorting. I have multiple top 10 lists in two groups like so:

However, if I apply a sort on one, the other gets affected as well. Is there a way to localize the sorting to just that list? I need to list the top 10 in either ascending or descending order.

 

[JoeMo]

If the column between the two lists is empty, sorting one table should have no affect on the other. Are you selecting a cell in the table/Column you want to sort before sorting?

 

[vulcanfury]

If the column between the two lists is empty, sorting one table should have no affect on the other. Are you selecting a cell in the table/Column you want to sort before sorting?

Yes. I've tried highlighting the three columns pertaining to the top 10 but the result is always the same. I've tried adding a filter in the headers to sort from there but it still affects the other one. I'm using Excel 2013 BTW.

EDIT:
I've figured it out. The values displayed are the results of fomulas using MATCH() and INDEX(). It turns out that the Qty sold in the right top 10 list uses the rankings on the left, so when I sort the left table, the right side changes as well.