Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the mode function Detra E. Excel Worksheet Functions 7 August 14th 07 09:05 PM
Mkae Mode function return "" instead of #N/A when there is no Mode Tonso Excel Discussion (Misc queries) 1 March 11th 07 10:38 AM
Mkae Mode function return "" instead of #N/A when there is no Mode Tonso Excel Discussion (Misc queries) 2 March 10th 07 05:10 PM
i think i need goal seek or other type of statistic function monkeytrader Excel Worksheet Functions 2 February 8th 07 11:39 AM
STATISTIC FUNCTION USING EXCEL.. I NEED AN EXPERT Moh Excel Worksheet Functions 1 September 10th 06 05:52 AM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"