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 foundOn 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
sample2.xls
Description: MS-Excel spreadsheet
