Re: $$Excel-Macros$$ UNIQUE values in Array

Thanks Kris > >From: Kris >To: excel-macros@googlegroups.com >Sent: Wed, 14 September, 2011 10:58:10 PM >Subject: Re: $$Excel-Macros$$ UNIQUE values in Array > >Hi, > > >I'm not sure you found a solution for this. This >link >http://www.excelfox.co

Re: $$Excel-Macros$$ UNIQUE values in Array

Hi, I'm not sure you found a solution for this. This link http://www.excelfox.com/forum/showthread.php?31-Data-Validation-Dependent-Dropdownsmight be a useful one. Kris -- -- Some important links for excel users:

Re: $$Excel-Macros$$ UNIQUE values in Array

Dear Yogi, Please see attached sheet for Reverse Vlookup Example =VLOOKUP(G4,CHOOSE({1,2},$B$2:$B$8,$A$2:$A$8),2,0) =LOOKUP(2,1/(B2:B8=G7),A2:A8) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Aug 17, 2011 at 12:03 PM, y

Re: $$Excel-Macros$$ UNIQUE values in Array

Hey Yogi, please find the attachment.,... there is a many way to put reverse vlookup.. like..IF count with choose functions,index with match function,lookup function,SUMPRODUCT function On Wed, Aug 17, 2011 at 12:03 PM, yogi yogi123 wrote: > > what is reverse vlookup.can u give one example.

RE: $$Excel-Macros$$ UNIQUE values in Array

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of yogi yogi123 Sent: Wednesday, August 17, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UNIQUE values in Array what is reverse vlookup.can u give one e

RE: $$Excel-Macros$$ UNIQUE values in Array

acros@googlegroups.com] On Behalf Of hanumant shinde Sent: Thursday, August 11, 2011 10:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UNIQUE values in Array Thanks but this will not work for me. i have already developed a function but i was thinking there must be some arra

Re: $$Excel-Macros$$ UNIQUE values in Array

guillett1 > To: excel-macros@googlegroups.com > Sent: Thu, 11 August, 2011 10:44:07 PM > Subject: Re: $$Excel-Macros$$ UNIQUE values in Array > > If I recall properly, your function skipped 1. How do you want it > presented??? > > -----Original Message----- > From: hanuman

Re: $$Excel-Macros$$ UNIQUE values in Array

If I recall properly, your function skipped 1. How do you want it presented??? -Original Message- From: hanumant shinde Sent: Thursday, August 11, 2011 11:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UNIQUE values in Array Thanks but this will not work for me

Re: $$Excel-Macros$$ UNIQUE values in Array

uillett1 > Subject: Re: $$Excel-Macros$$ UNIQUE values in Array > To: excel-macros@googlegroups.com > Date: Tuesday, 9 August, 2011, 10:31 PM > try > > Sub GetUnique() > Application.ScreenUpdating = False > Dim lr As Long > lr = Cells(Rows.Count, 1).End(xlUp).Row &g

Re: $$Excel-Macros$$ UNIQUE values in Array

e : Manual Work in Excel is not in our scope if we have VBA. Thanks Rajan Verma -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 09, 2011 8:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Exc

RE: $$Excel-Macros$$ UNIQUE values in Array

scope if we have VBA. Thanks Rajan Verma -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 09, 2011 8:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UNIQUE values in Array Will

Re: $$Excel-Macros$$ UNIQUE values in Array

Will data>advanced filter>unique work for you? -Original Message- From: Rajan_Verma Sent: Tuesday, August 09, 2011 9:04 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ UNIQUE values in Array Hi, I was trying to Get Unique List by Using Array Function and the

RE: $$Excel-Macros$$ UNIQUE values in Array

rday, August 06, 2011 9:59 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ UNIQUE values in Array Hope this will Help You. Function UniqueList(rng As Range, Pos As Long) As String Dim List() As String Dim cell As Range Dim i As Long Dim t As Long i = 0 R

Re: $$Excel-Macros$$ UNIQUE values in Array

t: Sat, 6 August, 2011 9:58:48 AM > Subject: RE: $$Excel-Macros$$ UNIQUE values in Array > > Hope this will Help You. > > Function UniqueList(rng As Range, Pos As Long) As String > Dim List() As String > Dim cell As Range > Dim i As Long > Dim

Re: $$Excel-Macros$$ UNIQUE values in Array

Thanks but i am not allowed to play with excel i jus can play with VBA. - Original Message > From: Omar > To: excel-macros@googlegroups.com > Sent: Sat, 6 August, 2011 4:17:34 PM > Subject: RE: $$Excel-Macros$$ UNIQUE values in Array > > Use advanced filter in re

RE: $$Excel-Macros$$ UNIQUE values in Array

Use advanced filter in recoding macro See this http://www.youtube.com/watch?v=B_sd5lJX65M -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hanumant shinde Sent: Friday, August 05, 2011 10:50 PM To: Excel Group Subject: $$Excel-Macr

RE: $$Excel-Macros$$ UNIQUE values in Array

Hope this will Help You. Function UniqueList(rng As Range, Pos As Long) As String Dim List() As String Dim cell As Range Dim i As Long Dim t As Long i = 0 ReDim List(rng.Cells.Count) As String For Each cell In rng flag = 0 For t = LBound(List) To UBound(List)