Fill cel per Past Majority

[poikl]

I'm sorry for repeating a question asked but being that I've not received any reply, I thought maybe it will help if I Explain my problem a little better and Added the Table below.
I have a running sheet "2010" which contains all production history, Product# in ColC and the Equipment used for that Product in ColG.
I have an Identical Current Sheet "2011" where I continue to enter the same data as it occurs.
I would hope that there's a Formula which can be entered in ColG (of the Current Sheet) where when I enter the Product#, it'll calculate from the History sheet and populate the adjacent ColG with the Equipment which was MOST used for THAT Product.
So in the case of Product# 1234, it'll Show in ColG TK7.
Thank you

A B C D E F G
Date Product #|||||||||||||||||||||||||||Equipment
4/3/2010 || 1234||||||||||||||||||||||||||||||||TK7
5/2/2010 || 3574||||||||||||||||||||||||||||||||TK12
5/20/2010|| 2122||||||||||||||||||||||||||||||||BT10
6/5/2010 || 1234||||||||||||||||||||||||||||||||TK7
6/17/2010 || 1234||||||||||||||||||||||||||||||||TK7
6/28/2010|| 5185||||||||||||||||||||||||||||||||BT10
7/3/2010|| 3565||||||||||||||||||||||||||||||||AR7
7/11/2010 || 1234||||||||||||||||||||||||||||||||AR12
7/19/2010|| 3574||||||||||||||||||||||||||||||||AR7
7/26/2010|| 5185||||||||||||||||||||||||||||||||BT10

 

[poikl]

Re: Fill cel per Past Majority-Please help

Can someone please take a look at this would be much appreciated