Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Labeling Part Numbers
Column A of my spreadsheet has a bunch of part numbers. I would like
to create a formula in Column B such that my parts are either labeled "American" or "Metric". Parts that are to be labeled "American", have one (or more than one) strings within their part number: PT<space<space TF<space<space <spaceNPTF <spaceNPS <spaceDOT<space <spaceUNF <spaceNPT <spaceNFPA If none of the above strings are within a part number, then the part is to be labeled "Metric". Can somebody please help me in creating the desired formula? Thanks. -- Tiziano |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Labeling Part Numbers
Create a table with your strings including the spaces.
See this screncap: http://img228.imageshack.us/img228/1858/americanod9.jpg Here's the formula entered in B2 then copied down: =IF(A2="","",IF(ISTEXT(LOOKUP(2,1/(ISNUMBER(SEARCH(G$2:G$9,A2))),G$2:G$9)),"American ","Metric")) -- Biff Microsoft Excel MVP "tb" wrote in message ups.com... Column A of my spreadsheet has a bunch of part numbers. I would like to create a formula in Column B such that my parts are either labeled "American" or "Metric". Parts that are to be labeled "American", have one (or more than one) strings within their part number: PT<space<space TF<space<space <spaceNPTF <spaceNPS <spaceDOT<space <spaceUNF <spaceNPT <spaceNFPA If none of the above strings are within a part number, then the part is to be labeled "Metric". Can somebody please help me in creating the desired formula? Thanks. -- Tiziano |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Labeling Part Numbers
on 11/6/2007 10:07 PM T. Valko wrote the following:
Create a table with your strings including the spaces. See this screncap: http://img228.imageshack.us/img228/1858/americanod9.jpg Here's the formula entered in B2 then copied down: =IF(A2="","",IF(ISTEXT(LOOKUP(2,1/(ISNUMBER(SEARCH(G$2:G$9,A2))),G$2:G$9)),"American ","Metric")) Thanks, Biff! -- Tiziano |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula For Labeling Part Numbers
"Tiziano" wrote in message
... on 11/6/2007 10:07 PM T. Valko wrote the following: Create a table with your strings including the spaces. See this screncap: http://img228.imageshack.us/img228/1858/americanod9.jpg Here's the formula entered in B2 then copied down: =IF(A2="","",IF(ISTEXT(LOOKUP(2,1/(ISNUMBER(SEARCH(G$2:G$9,A2))),G$2:G$9)),"American ","Metric")) Thanks, Biff! -- Tiziano You're welcome! -- Biff Microsoft Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Part Numbers | Excel Discussion (Misc queries) | |||
Identifying Part Numbers | Excel Worksheet Functions | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
Modification of Part Numbers | Excel Discussion (Misc queries) |