Consider using a pivot table. In the Rows area, specify by date, by code
number
In the data area, specify Count of code number
--
Gary''s Student - gsnu200753


"Karma2400" wrote:

Hi guys,

I think i've learned more about excel in the last few weeks of reading these
posts then the last 3 years of using them ;)

my problem this time .. i have a spreadsheet in which information is being
added by date and by a code number. I need to a formula similar to the Mode
function which will tell me the most often occuring code number in a specific
week number.

So basically i need to search conditionally by week number and identify not
only the most often occuring code but preferably the the 2nd and 3rd most
often occuring for that week.

That make sense ? ..

week number is just simply 43, 44 etc
Code numbers are in the format T1234 or PS0123

Any help would be great ! ..