I have two columns of Data that I wand to run an IF formular on and then a
Mode formula on the results.

Example:
A B C D
1 2 3
2 2 2
3 5 2
4 1 3
5 8 8
6 2 3

I want to be able to type into cell C1 a value that displays in column A e.g
"2" and for the formula only look at the data in column B if Column A = "2".
Then take the Data from column B and get the MODE of that Data.

So what I want to have happen is create a formular that would say work out
"if column A = 2 then the MODE of dats from Column B = 3. Then the answer can
be displayed in Cell D1.

Please help.