Unique values from range UDF

[vasim]

Hi Friends,

I have three range of data, lets say C2:C40, E2:E40, G2:G30 through some formula this range gets populated (a few cells goes as blank "").

I was wondering if someone can help me get some UDF (again UDF) to get the unique values from this range in I2:I40...

Image link: https://drive.google.com/file/d/0B9u_K1HbgiEKaUVadlZCX1BqNUk/edit?usp=sharing

THANKS IN ADVANCE...

 

[NARAYANK991]

Hi ,

This may be what you are looking for :

http://www.ozgrid.com/forum/showthread.php?t=86452

Narayan

 

[Smallman]

Hi Vasim

I had a look at Narayan suggestion on Ozgrid. I think I can suggest an alternative.

I will attach a workbook shortly, based on your jpeg file this should get you going.

Option Explicit

Sub RemDups()
    Dim rng As Range
    For Each rng In Rows(2).SpecialCells(2).Areas
        Range("I" & Rows.Count).End(xlUp)(2).Resize(rng.CurrentRegion.Offset(1).Rows.Count, _
        rng.CurrentRegion.Offset(1).Columns.Count) = rng.CurrentRegion.Offset(1).Value
    Next
    Columns("I:I").RemoveDuplicates 1
End Sub

Take care

Smallman

 

[vasim]

Hi ,

This may be what you are looking for :

http://www.ozgrid.com/forum/showthread.php?t=86452

Perfect....Narayan Thanks

Small Man thanks but I was looking for a UDF

EDITED (SirJB7)
Whenever you reply a post, take care of writing the new text off the quoted section: [ QUOTE ] [ / QUOTE ]