ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mode Statistic Function (https://www.excelbanter.com/excel-worksheet-functions/173979-mode-statistic-function.html)

johne

Mode Statistic Function
 
Hello,

I would like to calculate the mode for service start dates within an order
for a large number of orders. The orders contain a variable number of line
items where each line item contains a start date.

How may I apply "mode" and have the calculation restart for each new order
number?



johne

Mode Statistic Function
 
Please cancel this request. I accomplished the objective in Access.

"JohnE" wrote:

Hello,

I would like to calculate the mode for service start dates within an order
for a large number of orders. The orders contain a variable number of line
items where each line item contains a start date.

How may I apply "mode" and have the calculation restart for each new order
number?




All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com