Multiple tables – Sorting

Hi,

 

My problem is that I have two tables and one table that is combining (adding up) the two tables together and I want to be able to sort all 3 tables separately.

 

To make it clearer I can tell you that it’s sport statistics from 2 different teams that I want to combine so that I have stats from team 1 and stats from team 2 and also a combined total stats table (some players are playing in both teams).

So I want to sort my first table to show who’s got the most points from team number 1 and then sort the second table to show the same thing from team number 2. Then I want the combined table to count table 1 and 2 together and sort it to show the best total leader. 

Then I need to be able to add points and stats to table 1 and 2 during the season and again sort all tables.

Right now when I’m sorting the first table, the combined table’s player names switches position and show wrong stats for each player.

I am using Excel 2016 on Windows 7

BR. John

By: John

6 thoughts on “Multiple tables – Sorting

  1. yeezy shoes

    There are definitely numerous particulars like that to take into consideration. That is a great point to bring up. I supply the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in trustworthy good faith. I don?t know if finest practices have emerged around things like that, but I’m sure that your job is clearly recognized as a good game. Each boys and girls really feel the influence of only a moment抯 pleasure, for the remainder of their lives.

  2. longchamp handbags

    There are some interesting points in time in this article however I don抰 know if I see all of them middle to heart. There’s some validity but I’ll take hold opinion till I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as nicely

  3. Kanye West shoes

    I found your weblog website on google and verify a number of of your early posts. Continue to keep up the excellent operate. I just additional up your RSS feed to my MSN News Reader. In search of ahead to reading more from you afterward!?

  4. adidas stan smith

    There are some attention-grabbing closing dates on this article but I don抰 know if I see all of them heart to heart. There’s some validity but I will take maintain opinion till I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as effectively

Leave a Reply

Your email address will not be published. Required fields are marked *