| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking if a number appears within a cell
Hi, I have a column of cells that contain data that looks like this... VI 06 08 09 10 11 12 13 17 18 21 22 24 31 41 56 67 72 73 74 75 I would like the cell next to it to tell me if a number between 1 and 7 (inclusive) appears within this cell. I know how to check for the appearance of a string, but not a numeric value that falls within a specified range. Any help would be much appreciated moonrabbit -- moonrabbit ------------------------------------------------------------------------ moonrabbit's Profile: http://www.excelforum.com/member.php...o&userid=34119 View this thread: http://www.excelforum.com/showthread...hreadid=538898 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| select cell based on a number in another cell | New Users to Excel | |||
| First Number in a Cell | Excel Worksheet Functions | |||
Threaded Mode
