| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Search down a column fo a specific number of digits
Hi,
Am Wed, 3 Sep 2014 16:51:56 +0100 schrieb SVRider: A B c 1 4213211_ghdjk_null_2_ 4213212 True 2 4213212_ghdjk_null_7_ 4213211 True =COUNTIF($A$1:$A$100,B1&"*") will give you the number of matches =IF(COUNTIF($A$1:$A$100,B1&"*")0,"True","") will give you True if the number matches Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Search for specific number in a range | Excel Worksheet Functions | |||
| How to set a column to accept only a specified number of digits | Excel Programming | |||
| How to set a column to accept only a specified number of digits | Excel Worksheet Functions | |||
| How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Hybrid Mode
