Help Please

[Joe]

What i want to do is really simple.

I have column B with 50 numbers. I want to set up column C so that in
C2, if B2=B1 and then it returns a value or something like false. It
really doesn't matter what it returns though.

Then in C3, if B3=B2 OR B3=B1 then it returns the false value

Then in C4, if B4=B3 OR B4=B2 OR B4=B1 then it returns the false.

Then in C5, if B5=B4 OR B5=B3 OR B5=B2 OR B5=B1 then it returns the
false value.

Can anyone help please?

I think I could do it with alot of logical statements, but you can
only put 30 conditions into one cell. With a list of 50 numbers that
isn't enough, so Im kinda of stuck.

 

[JE McGimpsey]

One way:

C2: =IF(COUNTIF($B$1:B1,B2)=0,"")

Copy down as far as necessary.l

 

[Harald Staff]

See .misc. Please don't multipost, you waste people's time.

Best wishes Harald

 

[Bill Allen]

Enter in Cell C2:
=ISNA(VLOOKUP(B3,$B$2:B2,1,FALSE))
and then drag down.
The contents of cell C50 should look like this:
=ISNA(VLOOKUP(B50,$B$2:B49,1,FALSE))

If there's a match, then you'll get "false", otherwise, you'll get "true".

Regards,

Bill