One possibility:

Start in D1 and copy down.
=IF(COUNTIF(INDIRECT("A1:A" & ROW()),A1)2,A1,"")

HTH,
Paul



--

"mpenkala" wrote in message
...
Hi there,

I'm looking to do the following:
In column B I have either Q1,Q2,Q3 or Q4. What I'm looking for is for
Cell
D5 to check cells B1:B5 and if we have 3 of the same Q to show me that Q.
example:
ColB ColD
Q1
Q1
Q2
Q4
Q1 Q1 <----- since Q1 has been given 3 in the past five, I need
it
to show that

Any ideas? I could use multiple columns and do IF,AND,OR loops for each
individually, but there's gotta be an easier way.

Thanks,
Matt