why not? simply use =IF(COUNTIF($A$3:$A$15,C3)=0,"Text not found","Text found")
pfa -- *****Great day,* *viper* On Fri, Aug 26, 2011 at 4:57 PM, naanu v <naanu2...@gmail.com> wrote: > 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 >>> 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 >> > > -- > > ---------------------------------------------------------------------------------- > 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
sample2.xls
Description: MS-Excel spreadsheet
