Re: $$Excel-Macros$$ Unique list

2012-07-13 Thread NOORAIN ANSARI
gt;>> Can you give me a formula to retrieve this. >>> >>> >>> Thanks, >>> Joseph >>> Sent on my BlackBerry® from Vodafone >>> -- >>> *From: * NOORAIN ANSARI >>> *Sender: * excel-macros@googlegroups.com >>> *Date: *Thu,

Re: $$Excel-Macros$$ Unique list

2012-07-12 Thread joseph . camill
: $$Excel-Macros$$ Unique list Dear Joseph, Please try it.. Sub Unique_List_Creater() Dim i As Long Dim col As Long Dim rw As Long Dim sh As Worksheet Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set sh = ThisWorkbook.Sheets(3) sh.Range("F2:F" & sh.Ce

Re: $$Excel-Macros$$ Unique list

2012-07-11 Thread NOORAIN ANSARI
Dear Joseph, Please try it.. Sub Unique_List_Creater() Dim i As Long Dim col As Long Dim rw As Long Dim sh As Worksheet Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set sh = ThisWorkbook.Sheets(3) sh.Range("F2:F" & sh.Cells(Rows.Count, "F").End(xlUp).Row). Clea

Re: $$Excel-Macros$$ Unique list

2012-07-11 Thread NOORAIN ANSARI
Dear Seraj, Please check attached sheet, There is no solution in it. On Thu, Jul 12, 2012 at 9:51 AM, joseph camill wrote: > Hi Seraj, > > Attached is the reference sheet. > > Thanks, > Joseph > > On Thu, Jul 12, 2012 at 9:15 AM, Seraj Alam wrote: > >> Hi, >> >> Please attach the sheet for refer

Re: $$Excel-Macros$$ Unique list

2012-07-11 Thread Seraj Alam
Hi, Please attach the sheet for reference... Thanks Seraj On Wed, Jul 11, 2012 at 8:41 PM, wrote: > Hi experts, > > The formulae provided by the members is working fine when I have data in > one column. But if I have to do the same from multiple columns, then how do > I do? > > Thanks, > Josep