Help Please

J

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.
 
J

JE McGimpsey

See answer in

microsoft.public.excel

Please don't post the same message in multiple groups. It just tends to
fragment your answers, and it potentially wastes the time of those
answering questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm
 
Top