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

31 thoughts on “Multiple tables – Sorting

  1. coach bags

    A lot of thanks for all your valuable hard work on this website. My mom takes pleasure in doing internet research and it is obvious why. Almost all notice all concerning the dynamic means you produce worthwhile items through this web blog and even invigorate contribution from other people on this theme then our own child is in fact becoming educated a lot. Have fun with the rest of the new year. You are performing a brilliant job.

  2. hermes belt

    I as well as my guys came looking through the nice helpful hints located on your site while unexpectedly I had a terrible suspicion I never expressed respect to the website owner for those secrets. All the men appeared to be consequently excited to study all of them and now have quite simply been taking pleasure in them. Thanks for actually being so helpful and for getting certain excellent topics millions of individuals are really desirous to be informed on. My sincere regret for not expressing gratitude to you sooner.

  3. ig

    You are so interesting! I do not think I have read through a
    single thing like that before. So nice to discover someone with some unique thoughts on this subject.
    Really.. thank you for starting this up. This site is one thing that’s needed
    on the internet, someone with some originality!

  4. jordan shoes

    Thank you for all of the efforts on this site. My mom take interest in doing research and it is easy to understand why. My partner and i hear all relating to the compelling medium you offer valuable items via this website and in addition boost participation from some other people about this concern so our girl is certainly starting to learn a lot. Have fun with the remaining portion of the year. You have been doing a really great job.

  5. huarache shoes

    I must show my appreciation to the writer for rescuing me from this particular difficulty. As a result of browsing through the online world and meeting ways that were not beneficial, I figured my life was well over. Existing without the presence of solutions to the problems you’ve fixed by means of your entire blog post is a serious case, as well as ones that could have adversely damaged my career if I hadn’t come across your web site. The ability and kindness in controlling every part was invaluable. I’m not sure what I would’ve done if I had not discovered such a step like this. I can also now relish my future. Thanks for your time very much for the specialized and amazing guide. I will not think twice to refer your blog to anybody who needs to have assistance on this subject matter.

  6. coach outlet

    I am also writing to make you understand what a fine experience my wife’s girl encountered viewing yuor web blog. She discovered too many issues, most notably what it’s like to have a great teaching style to have the rest with no trouble learn specified advanced things. You truly exceeded my desires. Many thanks for coming up with the helpful, trusted, explanatory not to mention unique thoughts on your topic to Julie.

  7. Quincy Liljeberg

    Hello, you used to write magnificent, but the last several posts have been kinda boring… I miss your tremendous writings. Past few posts are just a little bit out of track! come on!

  8. polo ralph lauren

    I and also my guys ended up going through the great tips and hints located on the website then instantly got a horrible feeling I never expressed respect to the site owner for those secrets. My guys ended up as a result stimulated to read through them and have in effect honestly been enjoying them. Many thanks for simply being quite thoughtful and also for deciding on these kinds of remarkable themes millions of individuals are really desperate to be informed on. My honest apologies for not expressing gratitude to sooner.

  9. nike air vapormax

    A lot of thanks for all of your effort on this web page. Betty enjoys doing research and it’s easy to see why. Almost all notice all about the dynamic means you give practical strategies by means of this website and as well as boost participation from visitors about this point so our favorite daughter is without question studying a whole lot. Enjoy the remaining portion of the new year. You’re performing a fantastic job.

  10. kevin durant shoes

    I wanted to write you one little bit of word to be able to say thank you once again considering the great techniques you have documented at this time. It’s so seriously generous of people like you to deliver publicly precisely what many people could possibly have advertised as an electronic book to help make some cash for themselves, and in particular seeing that you might have tried it if you decided. The smart ideas as well acted as a good way to fully grasp other people online have the identical interest just as mine to realize very much more in terms of this issue. I know there are numerous more pleasurable opportunities up front for individuals who see your blog.

  11. jordan shoes

    I in addition to my guys ended up examining the good tricks on your web blog and then suddenly I had a terrible feeling I never expressed respect to the website owner for those secrets. The boys became so happy to see all of them and have in effect truly been using them. We appreciate you getting indeed helpful and for obtaining such magnificent resources most people are really wanting to understand about. Our own honest apologies for not expressing gratitude to you earlier.

  12. ferragamo belt

    I’m commenting to make you know what a cool discovery our daughter had using yuor web blog. She mastered some pieces, not to mention what it’s like to have a wonderful giving mood to let the rest without difficulty master a number of tortuous subject areas. You really did more than people’s desires. Thanks for coming up with the valuable, healthy, explanatory and also unique thoughts on that topic to Sandra.

  13. jordan 13

    My wife and i got so cheerful when Raymond could conclude his basic research through the entire ideas he got using your blog. It’s not at all simplistic just to always be handing out ideas people could have been making money from. And we all acknowledge we now have the writer to be grateful to for that. The explanations you made, the straightforward website menu, the relationships you will help promote – it’s got everything spectacular, and it’s really letting our son in addition to our family believe that that matter is brilliant, which is certainly highly important. Many thanks for the whole lot!

  14. coach outlet store online

    I’m also writing to make you understand what a helpful discovery my friend’s princess found reading your webblog. She noticed lots of things, with the inclusion of what it’s like to possess a wonderful teaching spirit to have other individuals smoothly learn about certain complex subject areas. You truly surpassed her expected results. I appreciate you for displaying those invaluable, trustworthy, explanatory as well as easy thoughts on your topic to Mary.

  15. off white hoodie

    A lot of thanks for all your work on this web site. My mum enjoys participating in research and it is easy to see why. A lot of people know all of the powerful way you present insightful techniques via your web site and strongly encourage participation from the others on that topic so our favorite daughter is always becoming educated a lot of things. Have fun with the remaining portion of the year. You have been performing a fantastic job.

  16. nike air max95

    I simply needed to thank you very much yet again. I am not sure the things that I would’ve followed without the actual advice provided by you on such area. Previously it was an absolute hard matter in my position, however , considering the well-written style you managed it made me to weep for contentment. Extremely grateful for this assistance and hope you comprehend what an amazing job you have been providing training others using your blog. Most likely you have never come across all of us.

  17. hermes belts

    I have to show my thanks to this writer for bailing me out of such a problem. After looking throughout the search engines and meeting strategies which were not pleasant, I believed my life was over. Living devoid of the approaches to the problems you have resolved by way of the review is a critical case, as well as those which could have adversely damaged my career if I had not encountered your web site. Your good training and kindness in controlling all areas was tremendous. I am not sure what I would’ve done if I hadn’t come across such a subject like this. I can also at this moment look ahead to my future. Thanks so much for your skilled and sensible guide. I won’t think twice to endorse the blog to any person who would need recommendations about this matter.

  18. yeezy boost 350

    I wanted to jot down a brief message to say thanks to you for those superb advice you are writing here. My time consuming internet research has finally been compensated with sensible facts and strategies to go over with my contacts. I would suppose that we visitors actually are undeniably blessed to live in a perfect site with many marvellous individuals with very beneficial solutions. I feel really grateful to have discovered your entire web site and look forward to many more cool moments reading here. Thanks again for all the details.

  19. jordan shoes

    Thank you so much for giving everyone an extraordinarily marvellous chance to read in detail from this web site. It can be so sweet and also stuffed with fun for me and my office peers to search your site nearly three times in one week to read through the newest guides you have got. And definitely, we are usually happy considering the dazzling knowledge served by you. Certain 3 ideas on this page are ultimately the most suitable I’ve had.

  20. birkin bag

    Needed to draft you this very small observation in order to say thanks the moment again for those gorgeous strategies you’ve discussed at this time. It is really particularly generous with you to supply easily all that many of us could have sold as an e-book in order to make some dough for their own end, and in particular considering that you might well have tried it if you decided. Those good tips additionally served like the good way to understand that the rest have the identical dreams just like my own to realize much more with respect to this problem. I am certain there are some more pleasurable occasions up front for people who looked at your blog.

  21. balenciaga

    I have to express thanks to you for rescuing me from this issue. After surfing around throughout the online world and coming across notions which were not pleasant, I assumed my life was gone. Living without the presence of strategies to the problems you’ve solved as a result of the short article is a critical case, and those that might have badly damaged my career if I had not come across your blog. Your main capability and kindness in playing with the whole lot was crucial. I’m not sure what I would’ve done if I had not encountered such a solution like this. I am able to at this point look ahead to my future. Thanks so much for the professional and effective help. I won’t be reluctant to propose the website to anyone who desires guidelines about this area.

  22. 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

  23. 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!?

  24. 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

  25. 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.

Comments are closed.