What equation that i need to use to group in vba

G

geniusideas

Hi,

I need to put group no in column 2 (each group contain 6 no), how to
do in vba?
Ex.
Col A Column B
1 1
2 1
3 1
4 1
5 1
6 1
7 2
8 2
9 2
10 2
11 2
12 2
13 3
and continue..

Please help what equation that i need to use to get no in column B
Thanks
 
M

Modeste

Bonsour® "geniusideas" a écrit
Hi,
I need to put group no in column 2 (each group contain 6 no), how to
do in vba?
Ex.
Col A Column B
1 1
2 1
3 1
4 1
5 1
6 1
7 2
8 2
9 2
10 2
11 2
12 2
13 3
and continue..

Please help what equation that i need to use to get no in column B

may be ?????
either
in B1=1+INT((ROW()-1)/6)
pull down in column "B"

or
numbers in column A must be continued sequency
in B1 =1+INT((A1-1)/6)
pull down as necessary
 
J

Jacob Skaria

Try

With Range("B1:B" & Cells(Rows.Count, "A").End(xlUp).Row)
..Formula = "=INT((A1-1)/6)+1"
..Value = .Value
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top