Find most frequent values among 30 last lines

Closed
Noar - Apr 29, 2010 at 05:40 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 29, 2010 at 09:17 AM
Hello everyone,

I would like to find the right formula to identify the 5 most frequent values (from 1 to 90) among a range comprising the 30 last lines of an Excel sheet, over 5 columns (C to G), and display them in decreasing order in another sheet.

Columns:
A= draw number (the case is based on a 5/90 lottery data)
B= date
C= 1st number drawn
D= 2nd number drawn
E= 3rd number drawn
F= 4th number drawn
G= 5th number drawn

Each line corresponds to 1 daily draw.

In short what I need is a formula which finds the 5 most frequently drawn numbers among the last 30 draws (and ideally sorts them from most to least frequent).

Thanks a lot in advance

Related:

2 responses

ramesh2412 Posts 79 Registration date Thursday November 19, 2009 Status Member Last seen September 5, 2011 13
Apr 29, 2010 at 07:04 AM
Use Pivot table or Vlook up or Hlook up
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 29, 2010 at 09:17 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0