*Thank you so much. I am very grateful to you. * ııllllııllıı ~ ♣ кαяαηη ♣ ~ ııllllııllıı
On Sun, May 8, 2011 at 6:59 AM, STDEV(i) <setiyowati.d...@gmail.com> wrote: > > try to use this UDF (user defined function) > Function UniqueList(Dat As Range) > ' List of UnSorted Unique Values ' > '-----------------------------------------' > Dim Cel As Range, vArr(), n As Long, Tx As String > Tx = ", " > For Each Cel In Dat > If InStr(1, Tx, ", " & Cel & ", ") = 0 Then > Tx = Tx & Cel & ", " > End If > Next Cel > If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2) > If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2) > UniqueList = Tx > End Function > > > > On Sat, May 7, 2011 at 3:50 PM, karan 1237 <karan1...@gmail.com> wrote: > >> * >> LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT >> SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT >> FRONT >> *Hi Experts, >> >> I want like this. Please help. >> >> Thnx in Advance. >> >> >> * >> ııllllııllıı ~ ♣ кαяαηη ♣ ~ ııllllııllıı >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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
