Thnx .. Excellent as always :) .. just working my way through the formula so
i can understand it .. can you tell me what this part does ? ..
(MATCH($B$2:$B$100,$D$1:D1,0)) .. the $D$1:D1,0 has me confused ..


" wrote:

Assuming that A2:A100 contains the week number, and B2:B100 contains
the code, try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

D2, copied down:

=INDEX($B$2:$B$100,MODE(IF($A$2:$A$100=44,IF($B$2: $B
$100<"",IF(ISNA(MATCH($B$2:$B$100,$D$1:D1,0)),MAT CH($B$2:$B$100,$B
$2:$B$100,0))))))

Hope this helps!

On Nov 1, 12:12 pm, 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 ! ..