Address of unique values

[Svgmassive]

Can i get the address on the unique records in a column to use in a range? thanks

 

[Ruddles]

Yes. If your value is in C1 and your lookup table is in column D starting at D1, this will do it:-

="D"&MATCH(C1,D:D,FALSE)

 

[Svgmassive]

Ruddles
That's not what i am looking for.what I need it to get the address of the unique values in a column.It should the first item of the unique values.

 

[texasaswang]

Can you give us a sample of your excel sheet to further explain?

 

[Svgmassive]

ok i am half way there i am trying to get the address of the unique value i have done an advance filter and added a formula to columns that has the address no how do i get put the addresses(values) in Range("Z5:Z6") in to a range without looping through the cells.Thanks
this is a copy of where i am at.i have not included all of the cells.i
Sub Macro2()

Range("F4:F7").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"X4:X7"), Unique:=True

With Range("Z5:Z6")
.FormulaR1C1 = "=ADDRESS(MATCH(RC[-2],C[-20],0),6)"
End With
End Sub