Thank u i would like to know is there any other formula in lookup or statistical or information
On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear nannu, > > See attached sheet, if it help > > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > 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 > -- ---------------------------------------------------------------------------------- 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
