Try this : =IF(ISERROR(MATCH(C3,$A$3:$A$15,0)),"Text Not found","Text Found")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 4:57 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ <viper....@gmail.com> wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- Great day, viper On Thu, Aug 25, 2011 at 8:51 PM, naanu <naanu2...@gmail.com> wrote: I want to know the formula to find out the solution. For Ex: I have two columns Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds 1 2 Nw i would like to sort column 2 in such a way that There should be different list in column 2 1. The values found in column 1 2. The values not available in column 1 Please help me out of the problem -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel