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.

Try this array formula** :

=MODE(IF(A1:A6=C1,B1:B6))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Karl" <The Moon wrote in message
...
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.

Does this solve? In D1 type the formula
=IF(A1=2,MODE($B$1:$B$6),"")
drag the formula to other cells in column D as you need.

"Karl" wrote:

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.