Hi, I want to get the 4 or 5 most frequent numbers out of 20.

[840496]

how can i get the most frequent 5 numbers(or more than 5) out of 20?
I have almost 1000 rows.
thanks


like this:

11

14​

16​

18​

23​

30​

32​

39​

41​

47​

48​

49​

50​

53​

58​

62​

64​

67​

72​

73​

4

6​

7​

8​

9​

16​

17​

21​

24​

35​

43​

46​

47​

49​

56​

59​

71​

74​

79​

80​

6

9​

17​

19​

28​

33​

39​

45​

46​

51​

55​

57​

58​

62​

63​

66​

76​

77​

78​

79​

2

4​

10​

18​

25​

28​

29​

34​

35​

37​

42​

44​

48​

55​

59​

61​

66​

69​

74​

79​

8

9​

11​

14​

23​

24​

29​

33​

40​

50​

55​

56​

60​

61​

62​

65​

66​

69​

72​

79​

1

4​

5​

10​

11​

16​

17​

20​

21​

24​

25​

36​

38​

47​

51​

54​

55​

57​

58​

80​

8

17​

18​

23​

26​

29​

35​

36​

39​

40​

57​

61​

62​

65​

66​

68​

69​

72​

73​

79​

3

12​

13​

23​

32​

33​

34​

36​

41​

49​

50​

53​

57​

58​

61​

62​

65​

67​

73​

75​

1

2​

5​

13​

17​

21​

24​

25​

26​

40​

43​

44​

50​

56​

60​

64​

67​

74​

76​

77​

8

17​

19​

20​

24​

25​

26​

29​

31​

33​

42​

51​

63​

69​

70​

72​

75​

77​

78​

80​

4

10​

15​

18​

21​

25​

26​

27​

29​

31​

39​

42​

44​

46​

58​

60​

67​

68​

72​

80​

10

17​

27​

28​

30​

31​

35​

42​

45​

47​

50​

53​

56​

58​

62​

63​

64​

65​

69​

75​

2

5​

9​

10​

21​

23​

24​

26​

32​

36​

41​

42​

54​

59​

60​

64​

65​

66​

68​

70​

6

9​

21​

23​

24​

31​

32​

34​

38​

51​

52​

53​

55​

57​

59​

66​

70​

71​

76​

78​

1

2​

6​

14​

20​

31​

32​

34​

38​

39​

41​

43​

44​

50​

51​

52​

54​

67​

75​

80​

3

7​

17​

27​

31​

33​

40​

41​

49​

53​

54​

58​

60​

63​

64​

69​

73​

76​

79​

80​

1

3​

13​

17​

21​

24​

29​

34​

37​

41​

45​

47​

51​

52​

55​

58​

59​

62​

71​

77​

1

4​

12​

17​

21​

27​

30​

36​

39​

42​

47​

51​

54​

58​

61​

63​

65​

67​

69​

71​

1

8​

12​

16​

19​

22​

25​

31​

38​

45​

52​

60​

61​

68​

69​

70​

71​

76​

78​

80​

6

7​

8​

11​

14​

19​

29​

30​

35​

42​

43​

47​

48​

53​

54​

60​

63​

67​

68​

73​

 

[JvdV]

You want the 5 most frequent number for each row? or for the whole block? If by row (which appears to match the 20 numbers), what would be your desired result for 1st row since all numbers appear just once?

 

[840496]

You want the 5 most frequent number for each row? or for the whole block? If by row (which appears to match the 20 numbers), what would be your desired result for 1st row since all numbers appear just once?

thanks for reply.
actuall this is for lottery game like Keno.
every row is a winning number combination.
I'm trying to find the odds.

 

[840496]

Sample：A1-H5
0 1 2 3 4 5 6 11
0 1 2 3 5 9 10 11
1 3 4 5 8 9 10 11
0 1 3 5 7 9 11 12
0 4 5 7 8 9 11 12

in this 5 raws, the most frequent number combination is 1 3 5 11.