search

Temtesb / StatisticsCalculationsForExcel

VBA functions for statistics calculations to be used in Excel and Access
Other
7 stars 1 forks source link

Add new Mode function for acces only #9

Open seakintruth opened 7 years ago

seakintruth commented 7 years ago

This all should return the mode of a set of data SELECT TOP 1 Table1.Data FROM Table1 GROUP BY Table1.Data ORDER BY Count(Table1.Data) DESC;

Temtesb commented 7 years ago

Nice! I will be needing that at work this week. :)

On Feb 4, 2017 13:22, "Jeremy D. Gerdes" notifications@github.com wrote:

This all should return the mode of a set of data SELECT TOP 1 Table1.Data FROM Table1 GROUP BY Table1.Data ORDER BY Count(Table1.Data) DESC;

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Temtesb/StatisticsCalculationsForExcel/issues/9, or mute the thread https://github.com/notifications/unsubscribe-auth/AYGMRKqgKL-ADNzaLs_RYaanG1HB0Indks5rZMHvgaJpZM4L3On4 .

seakintruth commented 7 years ago

Of course, this does not return multiple results if there is more than one mode.