If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|