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

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