a little addition to Dilip's solution see the attached file
On Thu, Feb 19, 2009 at 1:39 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Prabhat, > > One dirty way may be:- > > Column A Column B Column C Column D 1 a =IF(A2=1,B2,"") > =C2&C3&C4&C5&C6&C7 2 b =IF(A3=1,B3,"") 1 c =IF(A4=1,B4,"") 1 d > =IF(A5=1,B5,"") 3 e =IF(A6=1,B6,"") 4 f =IF(A7=1,B7,"") > > Now, if you drag the column C till the range you want, you have the result > in D1. > Note, you need to update the formula in column D as well. > > For updating the formulas, you can use series in excel and then you can > concatenate them using &, "", , etc. special characters. > > Thanks. > Dilip Kumar Pandey > -- > *DILIP KUMAR PANDEY > * B COM(Hons.),BCA,MBA > Mobile: +91 9810929744 > South Niketan, > Dr. Ambedkar Nagar > New Delhi - 110062 > > On Wed, Feb 18, 2009 at 11:03 PM, prabhat.shrivasta...@gmail.com < > prabhat.shrivasta...@gmail.com> wrote: > >> >> Dear All, >> I want to know the formula to which retrieve multiple data from single >> column. >> >> 1 a >> 2 b >> 1 c >> 1 d >> 3 e >> 4 f >> >> lookup Value is 1 and data should retrieve all written in front of 1 >> i.e. a,c and d. >> >> Thanks and Rgds >> Prabhat Shrivastava >> >> >> > > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
fdsdsf.xls
Description: MS-Excel spreadsheet
