Its OK Anish, I can understand the frustration... I am also sorry for my hard words..
CHEERS!! Andy On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava <anish....@gmail.com>wrote: > Thanks Aindril for your help. > > N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later > tht it wasnt a right way...was kinda frustrated in office.. :( > > > > On 11/13/09, Aindril De <aind...@gmail.com> wrote: >> >> Dear Anish, >> >> You would need a UDF for this: >> >> Use the following code : >> >> Option Explicit >> >> Public Function vlookupall$(strSearch As String, rngRange As Range, >> lngLookupCol As Long) >> >> 'Vlookupall searches in first column of rngRange for strSearch and returns >> corresponding >> 'values of column lngLookupCol if strSearch was found. All corr. values >> are collected and >> 'returned in one string (result of function). >> >> Dim i As Long >> If lngLookupCol > rngRange.Columns.Count Then >> vlookupall = CVErr(xlErrValue) >> Exit Function >> End If >> vlookupall = "" >> For i = 1 To rngRange.Rows.Count >> If rngRange(i, 1).Text = strSearch Then >> >> vlookupall = vlookupall & rngRange(i, lngLookupCol).Text & ", " >> >> End If >> Next i >> End Function >> >> Insert a Module and Paste the above code in that. >> >> Then in the cell B2 type the new formula. >> The attached file has the solution..... >> >> Thanks to : http://www.sulprobil.com/html/vlookupall.html >> >> *And for GOD's sake please donot write like what you had.. to someone who >> is trying to help you....* >> This is a forum where everyone is welcome and we try to help each other. >> If by any chance someone is not able to help/understand your problem. Then >> someone else will help you. So please be patient. Tomorrow when you try to >> help someone you will not like that person writing like this to you... >> Right!!! >> >> Regards, >> Andy >> >> >> On Fri, Nov 13, 2009 at 5:45 PM, Anish Shrivastava >> <anish....@gmail.com>wrote: >> >>> Hi Punit, >>> >>> Thanks for you helping attempt, but tht's not wht I want. You used just >>> vlookup in 2 cells...I m afraid to say tht but even I know tht much of >>> basics (No offence). Could you please let me know wht if the occurance is 3 >>> times. :P >>> >>> Cheers!! >>> ANISH >>> >>> On Fri, Nov 13, 2009 at 3:06 PM, punit poddar <p2pod...@gmail.com>wrote: >>> >>>> Hi >>>> >>>> You can use the file attached below: >>>> >>>> Punit >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >>>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com or >>>> Ashish Jain @ 26may.1...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,500 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group. Our goal is to have 10,000 >>>> subscribers by the end of 2009. Let friends and co-workers know they can >>>> subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 2. Excel tutorials at http://www.excel-macros.blogspot.com >>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com or >>> Ashish Jain @ 26may.1...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,500 subscribers worldwide and receive many nice notes >>> about the learning and support from the group. Our goal is to have 10,000 >>> subscribers by the end of 2009. Let friends and co-workers know they can >>> subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 2. Excel tutorials at http://www.excel-macros.blogspot.com >> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com or >> Ashish Jain @ 26may.1...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group. Our goal is to have 10,000 >> subscribers by the end of 2009. Let friends and co-workers know they can >> subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
