Researching single and unambigous pairs prolem....

[Xerses]

I've got a worksheet with a column of data like A:

A B
4 Match
5 Mismatch
4 Match
4 Mismatch
6 Match
2 Mismatch
1 Mismatch
6 Match

I'm trying to find a formula or a macro that could give me an output
like in column B....The big problem is that i need to find only single pairs
of data (E.G: the first two "4" are matching, the third one is mismatching
because there isn't another one in column A). I've tried with countif and
offset but they doesn't work.

Someone could give me an hint on a formula or a macro?
Thanks for your time.

Live Long and Prosper,
Xerses from Home.

 

[Frank Kabel]

Hi
one way: enter the follwoing formula in B1:
=IF(MOD(COUNTIF($A$1:$A$100,A1),2)=0,"Match",IF(COUNTIF($A2:$A$100,A1),
"Match","Mismatch"))
and copy this formula down

 

[Xerses]

Frank Kabel wrote:

|| Hi
|| one way: enter the follwoing formula in B1:
|| =IF(MOD(COUNTIF($A$1:$A$100,A1),2)=0,"Match",IF(COUNTIF($A2:$A$100,A1),
|| "Match","Mismatch"))
|| and copy this formula down
||
cut

Thank for the help, but it doesn't work.... I've tried and tested and it
gives me only "Match" output... :-(
I'll work on it!

Thanks again, bye!

Live long and prosper,
Xerses from home.

 

[Frank Kabel]

Hi
if your data is in A1:A100 it should work. At least it did on my
testdata

 

[Xerses]

Frank Kabel wrote:
|| Hi
|| if your data is in A1:A100 it should work. At least it did on my
|| testdata
cut

You are right. I've recheked the formula and it worked fine...I've made
a stupid translation error (I'm at home and here my excel is not in
english).

Thanks, you are great!

Live long and prosper,
Xerses from home.