Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What equation that i need to use to group in vba
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What equation that i need to use to group in vba
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What equation that i need to use to group in vba
Try
With Range("B1:B" & Cells(Rows.Count, "A").End(xlUp).Row) ..Formula = "=INT((A1-1)/6)+1" ..Value = .Value End With -- Jacob (MVP - Excel) "geniusideas" wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What equation that i need to use to group in vba
Thanks YOU Jacob.
it work! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range.Group Method - group rows, not columns | Excel Programming | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |