Unique list in between range.

[Kamran01]

Dear Seniors,

I would like to share a question regarding unique list in between range.
I have a data in which Column A have a range 1 to 999 and all are unique values.

I want to show 1-333 rows data in Column B
I want to show 334-666 rows data in Column C
I want to show 667-999 rows data in Column D

is there anyway to find all these data easily in Excel.

Looking forward for your prompt response,

best Regard,
Kamran Noor

 

[MickG]

Try this:-

[COLOR="Navy"]Sub[/COLOR] MG17Apr47
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, ac [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
ac = 2
[COLOR="Navy"]Set[/COLOR] Rng = Range("A1:A999")
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
    c = c + 1
    Cells(c, ac) = Dn.Value
        [COLOR="Navy"]If[/COLOR] c Mod (Rng.Count / 3) = 0 [COLOR="Navy"]Then[/COLOR]
            ac = ac + 1: c = 0
        [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[Kamran01]

Thank you MickG, Done.