Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Function
Dear all
i have in sheet 1 -- A1 an account 1000_hc45 in sheet 2 in column A and in300 lines i have formulas which import from txt and showed as : 1000_hc45+#1000_hc100+#1000_reg There is any way to track in sheet 1 if the account of A1: 1000_hc45 exist in any part of sheet 2 Column A? Just ot find the account in the text, exact the same account. Thanks in advance Manos |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Function
Try something like this:
Sheet2!A1:A100 contains various text, some of which may contain 1000_hc45 On Sheet1 A1: 1000_hc45 This formula returns TRUE if at least one cell in Sheet2!A1:A100 includes the text in A1: B1: =COUNTIF(Sheet2!A1:A100,"*"&A1&"*")0 Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Manos" wrote in message ... Dear all i have in sheet 1 -- A1 an account 1000_hc45 in sheet 2 in column A and in300 lines i have formulas which import from txt and showed as : 1000_hc45+#1000_hc100+#1000_reg There is any way to track in sheet 1 if the account of A1: 1000_hc45 exist in any part of sheet 2 Column A? Just ot find the account in the text, exact the same account. Thanks in advance Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search / Mid function | Excel Worksheet Functions | |||
Search function | Excel Discussion (Misc queries) | |||
SEARCH function | Excel Worksheet Functions | |||
Search and Get Function Help | Excel Worksheet Functions | |||
a search function | Excel Worksheet Functions |