| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
check if value occurs within a range
I have the following in column A : A 1 2 3 4 3 4 5 3 4 5 1 3 How do I find out if the number 1 is found in Column A. Column A contains either a single entry or multiple entries separated by "ALT+Enter" (Chr(10)). I don't care if it is there more than once, only if it is there at all. Any suggestions? TIA Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=383726 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a formula check if a value occurs within a range? | Excel Worksheet Functions | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| check occurrence of items in a range | Excel Discussion (Misc queries) | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
Threaded Mode
