| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check the value?
Does anyone have any suggestions on how to check the value from a list of
numbers? For example, there is a list of number under A column, and there is a given number in cell B1. If I find any number under A column, which match the given number in cell B1, then return True in cell C1, else return False in cell C1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to check the value?
In C1, copied down: =IF(B1="","",ISNUMBER(MATCH(B1,A:A,0)))
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eric" wrote: Does anyone have any suggestions on how to check the value from a list of numbers? For example, there is a list of number under A column, and there is a given number in cell B1. If I find any number under A column, which match the given number in cell B1, then return True in cell C1, else return False in cell C1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to check the value?
Give this a try...
=ISNUMBER(MATCH(B1,A:A,0)) Rick "Eric" wrote in message ... Does anyone have any suggestions on how to check the value from a list of numbers? For example, there is a list of number under A column, and there is a given number in cell B1. If I find any number under A column, which match the given number in cell B1, then return True in cell C1, else return False in cell C1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
Hybrid Mode
