| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to check whither a text is existed
Please help me.
Example: I have data in Column A as following: A1: G111 A2: G112 A3: G113 I have updated date in Column C as following: C1: G112 C2: G113 C3: G114 Now, I want a function or formula to be entered in Column B, so it checks A1 value if it is existed in any of Column C cells, I want it to check all cells in Column C. After that I will be able to check the others A2, A3 €¦ Please help me. -- MFS22 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to check whither a text is existed
Try this:
Entered in B1 and copied down as needed: =IF(COUNTIF(C$1:C$100,A1),"Y","N") Y = yes, it's there N = no, it's not there Adjust for the correct end of range C$100. -- Biff Microsoft Excel MVP "MFS" wrote in message ... Please help me. Example: I have data in Column A as following: A1: G111 A2: G112 A3: G113 I have updated date in Column C as following: C1: G112 C2: G113 C3: G114 Now, I want a function or formula to be entered in Column B, so it checks A1 value if it is existed in any of Column C cells, I want it to check all cells in Column C. After that I will be able to check the others A2, A3 . Please help me. -- MFS22 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to check whither a text is existed
Thank you T. Valko (I want to kiss you) you are my hero.
I just adjusted it like this: =IF(COUNTIF(C$1:C$100;A1);"y";"n") I changed "," to ";" as you can see Now it is working very well, thanks T. Valko -- MFS22 "T. Valko" كتب: Try this: Entered in B1 and copied down as needed: =IF(COUNTIF(C$1:C$100,A1),"Y","N") Y = yes, it's there N = no, it's not there Adjust for the correct end of range C$100. -- Biff Microsoft Excel MVP "MFS" wrote in message ... Please help me. Example: I have data in Column A as following: A1: G111 A2: G112 A3: G113 I have updated date in Column C as following: C1: G112 C2: G113 C3: G114 Now, I want a function or formula to be entered in Column B, so it checks A1 value if it is existed in any of Column C cells, I want it to check all cells in Column C. After that I will be able to check the others A2, A3 . Please help me. -- MFS22 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to check whither a text is existed
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "MFS" wrote in message ... Thank you T. Valko (I want to kiss you) you are my hero. I just adjusted it like this: =IF(COUNTIF(C$1:C$100;A1);"y";"n") I changed "," to ";" as you can see Now it is working very well, thanks T. Valko -- MFS22 "T. Valko" ???: Try this: Entered in B1 and copied down as needed: =IF(COUNTIF(C$1:C$100,A1),"Y","N") Y = yes, it's there N = no, it's not there Adjust for the correct end of range C$100. -- Biff Microsoft Excel MVP "MFS" wrote in message ... Please help me. Example: I have data in Column A as following: A1: G111 A2: G112 A3: G113 I have updated date in Column C as following: C1: G112 C2: G113 C3: G114 Now, I want a function or formula to be entered in Column B, so it checks A1 value if it is existed in any of Column C cells, I want it to check all cells in Column C. After that I will be able to check the others A2, A3 . Please help me. -- MFS22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text box over check box | Excel Discussion (Misc queries) | |||
| Bold text in check box | Excel Discussion (Misc queries) | |||
| Check Box Text | Excel Discussion (Misc queries) | |||
| Which function to check any value existed withing a list? | Excel Discussion (Misc queries) | |||
| Which function to check any value existed withing a list? | Excel Worksheet Functions | |||
Linear Mode
