limit text entry in a range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a range of cells (A1:A4) with an in cell drop down-list using
data validation. I want to limit the entry from the list to only one of the
four cells. If A1 has an entry I need to restrict entry in A2:A4. If A2 has
an entry I need to restrict entry in A1,A3, & A4 etc.

Note: I am using SUMIF to total columns 1-4 based on the entry of from the
drop-down list.
 
How about just using an adjacent cell (B1???) with a formula like:

=if(counta(a1:a4)<2,"","Please--only one entry in A1:A4")

Format as big bold red letters.
 

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

Data Validation 4
Combining Text From Cells 3
Mutiply in a range of cells ? 1
Conditional Printing 2
Addition function of multiple cells 10
Sum number range ignoring numbers formatted as text 0
Multiple entries query 6
Tab Names to Match Cell Values when Changed 8

Back
Top