Help with formula

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

I would like Col B to test Col A and enter a Y, N, or nothing

In Cell B2:

If A2 <> A3, place a "Y" in B2, otherwise "N"
OR
If A2 = "" then don't place anything in B2

Thanks -- Suz
 
Thanks -- I was working the formula backward.

Is there any way to do this in data validation? (the number of rows may vary
between 2 and 2,000)
 
Sure. We just need to assume that either A2 is entered first and the
validation go on A3 or visa versa.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows takes forever 4
Looping through cells and holding values 5
Reconstructing a table with Arrays 1
CONCATENATE code 2
After sort and concant, one too many semi-colon 15
Find string from column A in Range("B2:F7") list the header of that column/s 5
Combo and List box combination 2
*Assistance with formula* 3

Back
Top