geedee65
09-12-2007, 06:21 AM
I'm looking for a formula that will return the most frequent text in an array.
In the worksheet 'Day', the daily wind direction is recorded in column B, with the date in column A.
In the 'Week' worksheet I would like to return the most frequent wind direction for that week, with the same in the 'Month' worksheet and the 'Year'.
Does anyone know how to do this with a formula (that preferably can be copied down as the real workbook has 10 years of data) or vba.
Also, normally with the rainfall totals and averages in the 'Week', 'Month' & 'Year' worksheets I would put a formula in a cell and select the required range from the 'Day' worksheet, but with a large amount of data this is very time consuming!!!!
Is there a formula that will achieve this, but can be copied down?
or is there a way to do this in vba?
I've attached the sample workbook.
In the worksheet 'Day', the daily wind direction is recorded in column B, with the date in column A.
In the 'Week' worksheet I would like to return the most frequent wind direction for that week, with the same in the 'Month' worksheet and the 'Year'.
Does anyone know how to do this with a formula (that preferably can be copied down as the real workbook has 10 years of data) or vba.
Also, normally with the rainfall totals and averages in the 'Week', 'Month' & 'Year' worksheets I would put a formula in a cell and select the required range from the 'Day' worksheet, but with a large amount of data this is very time consuming!!!!
Is there a formula that will achieve this, but can be copied down?
or is there a way to do this in vba?
I've attached the sample workbook.