mode function

Hello all - I have been given some great help recently in trying to return the MODE of a series of TIMES (as in times of day). This has been very helpful, and I thank you all. Now I have hit a snag in implementing it. In col C2 I have the following formula: =IF(Main!DG3="X",Main!G3,"") This...

Hello - I am trying to derive the MODE of a sequence of times. I have the following format to convert: 12:00:00 EDT I imagine it does need to be converted Into text or number format so as to derive the MODE of this sequence. I have tried several approaches to no avail. I also wish to derive...

Hello, I am a teacher and have a grade tracking grid. We would like to add a column to calculate the mode of all scores for each student. The grid currently has 6 units of work which each has 4 grades in. I would like to find the mode for all grades whilst dismissing any fields left blank...

I'm making a spreadsheet for work purposes and cannot quite manage to figure out a formula for some of the data they require, the info is as follows: TAB Name: APPS Column A: Surname Column B: Forename Column C: Sex (M/F) In a separate tab ('INFO') I need to calculate the most frequently...

I'm making a spreadsheet for work purposes and cannot quite manage to figure out a formula for some of the data they require, the info is as follows: TAB Name: APPS Column A: Surname Column B: Forename Column C: Sex (M/F) In a separate tab ('INFO') I need to calculate the most frequently...

Hello everyone, I have a pivot table and I'd like to calculate the mode for the week. My data table is arranged by day. The field (in the data table) I'm interested in using is hours. I don't care if the calculation is done within the pivot table or outside. It seems to me that something...

Hi, Looking for someone wiser than me to help. I have a list of unique part numbers in a summary sheet for which I wish to assign a description. In a seperate sheet, I have a data table, consisting of part numbers and descriptions. Not all descriptions per part number are identical, and so, in...

Hi, I have a set of schedule data which includes each employee's team name and their start time. Some teams include people who have a mix of start times, others include just people with the same start times. I'd like a way to summarise the most common start time in each team and I was trying to...

Hi. I know there are many many similar threads to this, but I can't get any of them to work for me. I don't know a lot about VBA which is a shame. I'm trying to get to grips with it, because I'm certain it'll make my life easier. In the meantime, maybe one (or more) of you guys can. I basically...