The most common league-prediction?

[mrprediction]

Hi

I want to use several (10 or so) professional league table predictions (football) and kind of merge them into one, to see the most common answer.

How can i proceed? I am a novice but have 'some' experience.

Thanks in advance.

 

[Peter_SSs]

Welcome to the MrExcel board!

Pretty hard to make a useful suggestion without seeing some sample data (say 3 or 4 small prediction tables) and the expected results from those tables so that we can get an idea of the data layout and structure. Examples should include at least one where there is more than one equal most common answer. For example, with 4 tables two tables predict "a" and two tables predict "b".

 

[mrprediction]

Welcome to the MrExcel board!

Pretty hard to make a useful suggestion without seeing some sample data (say 3 or 4 small prediction tables) and the expected results from those tables so that we can get an idea of the data layout and structure. Examples should include at least one where there is more than one equal most common answer. For example, with 4 tables two tables predict "a" and two tables predict "b".

Thanks for replying.

Are just two tables not enough? Here's two examples. I'd like to combine them somehow.

1. Leicester
2. Leeds
3. Southampton
4. Middlesbrough
5. Ipswich
6. West Brom
7. Swansea
8. Sunderland
9. Millwall
10. Coventry
11. Norwich
12. Stoke
13. Watford
14. Bristol
15. Sheffield Wednesday
16. Blackburn
17. Hull
18. Birmingham
19. Preston
20. Cardiff
21. Huddersfield
22. Rotherham
23. Queens Park Rangers
24. Plymouth


1. Middlesbrough
2. Leicester
3. Coventry
4. Swansea
5. Sunderland
6. Leeds
7. Southampton
8. Millwall
9. Blackburn
10. West Bromwich
11. Bristol
12. Huddersfield
13. Norwich
14. Stoke
15. Watford
16. Preston
17. Hull
18. Ipswich
19. Cardiff City
20. Sheffield Wednesday
21. Birmingham
22. Rotherham
23. Plymouth

• Queens Park Rangers

 

[Peter_SSs]

Well, what do you mean by this?

merge them into one, to see the most common answer.

.. and what about this for those 2 tables?

and the expected results from those tables

That is, given those 2 tables, what result(s) do you want?