how do i check if a number is repeating

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

Guest

well, being more clear, i got to enter different invoices numbers i would
like to make sure i dont enter the same inv# more than one time. can anyone
help me please. oh! and another one how do i enter a text as a formula. for
example, ny city.

thank you.
 
hi, jim thank you for you help.
i want the information on a1 to appear on c1 but lets say that is a city.
so i know how to do the formula with numbers but not text. i hope you
anderstand what i'm trying to say.
thank you.
 
You can use data validation for your first request to avoid duplicates.

Assuming you are data enterin in column A, Select A1 and then select the
entire column. Now Select Data -> Validation -> Custom and add the formula

=COUNTIF(A:A, A1) = 1

As for your second question I have no idea what you are looking to do. Can
you rephrase?
 
hi, i got one more question, i did the data validation but in one workbook i
have about 6 worksheet. can i use this formula so all the worksheets dont
duplicate.for example: if i'm working on sheet 1 and enter a invoice thats
already on sheet 2 will let me know. thank you.
 
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

matching a column of numbers to another in another spreadsheet 1
how do I extract only certain data from a cell? 6
Inseart row if cell number is repeating 2
Duplicates in a list 1
merge 3
Combobox filtering 2
HOW DO I ENTER THE FORMULA TO LOOK UP 2
How do I remove Duplicate rows? 15

Back
Top