LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MFS MFS is offline
external usenet poster
 
Posts: 36
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text box over check box Mr. Jim Excel Discussion (Misc queries) 0 September 10th 07 07:02 PM
Bold text in check box denise Excel Discussion (Misc queries) 3 September 13th 06 11:24 PM
Check Box Text Karen Excel Discussion (Misc queries) 1 February 2nd 06 08:02 PM
Which function to check any value existed withing a list? Eric Excel Discussion (Misc queries) 1 December 31st 05 12:38 AM
Which function to check any value existed withing a list? Eric Excel Worksheet Functions 1 December 31st 05 12:35 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"