How will I know if I use the same number twice?
 

I am trying to set up a speadsheet, where we can track how much a company
charges us for certain items. We want to make sure they are charging us the
same amount every time. I want to know how to set it up, so that if I type
in an item number that is already on the spreadsheet, it will let me know?

How will I know if I use the same number twice?
 

Very easy. Put your number in cell A1 and in B1 enter:
=COUNTIF(C:IV,A1)+COUNTIF(A2:B65536,A1)


If the number in A1 is not repeated elsewhere on the sheet, B1 will return a
one. If the number you entered in A1 is repeated on the sheet, B1 will
return the number of additional entries.
--
Gary's Student


"nunkinhid3" wrote:

I am trying to set up a speadsheet, where we can track how much a company
charges us for certain items. We want to make sure they are charging us the
same amount every time. I want to know how to set it up, so that if I type
in an item number that is already on the spreadsheet, it will let me know?