please help simple spreadsheet

  • Thread starter Thread starter M.J. Nielsen MN3 USN
  • Start date Start date
M

M.J. Nielsen MN3 USN

All I want is a spread sheet that I cannot enter the same
number twice, nothing more then that, I am very new to
this program, please help me. Thank you!
 
M.J.,

Data Validation lets you control what's allowed to be entered into cells.
The following is for B2:B10, change the formula below to match your cells.
Select the cells to be monitored, Data - Validation - Custom:

=COUNTIF($B$2:$B$10,B2)=1

Observe the absolute and relative cell references ($). Change the last B2
to match the active (white) cell in your selection.

It's better to use a more descriptive subject line in your posts. More
people are likely to read it. Something like "Not allow duplicate entry."

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Back
Top