| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Datbase check
I have a database of 12 different numbers, contained in the same column, on
12 successive rows. Does anyome know if Excel is able to check whether a number entered elsewhere on the worksheet is the same as a number in the database? Many thanks |
|
#2
|
|||
|
|||
|
Yes.
If the number is always going to be entered in a specific location, you could use conditional formatting. If A1:A12 contains your "database" and D12 is where the new entry is going to be, the condition would be: =OR(D12=$A$1:$A$12) -- Vasant "gunga" wrote in message ... I have a database of 12 different numbers, contained in the same column, on 12 successive rows. Does anyome know if Excel is able to check whether a number entered elsewhere on the worksheet is the same as a number in the database? Many thanks |
|
#3
|
|||
|
|||
|
Thanks for your help. I've found that =MATCH offers an even better solution.
"Vasant Nanavati" wrote: Yes. If the number is always going to be entered in a specific location, you could use conditional formatting. If A1:A12 contains your "database" and D12 is where the new entry is going to be, the condition would be: =OR(D12=$A$1:$A$12) -- Vasant "gunga" wrote in message ... I have a database of 12 different numbers, contained in the same column, on 12 successive rows. Does anyome know if Excel is able to check whether a number entered elsewhere on the worksheet is the same as a number in the database? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| spell check protected document | Excel Discussion (Misc queries) | |||
| Using a Check Box as a control item | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Linear Mode
