| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If A1=H Then B1=1, Excel 2000 & 2003
Ken -
Like mine, only better. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Ken Johnson" wrote in message ups.com... Hi jfcby, If your data starts in A1 then fill the following formula down column B =MATCH(A1,{"H","WH","O","B","AN"},0) Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 and Excel 2003 in Office 2003 | New Users to Excel | |||
| Excel 2000 to excel 2003 Window's 2003 XP Pro | Excel Programming | |||
| Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
| MS Excel 2000 & VS .NET 2003 | Excel Programming | |||
| Excel 2000 and 2003 | Excel Programming | |||
Threaded Mode
