Sequential number within excel

Please see the data below

a b c
000000080672 EI0G18 1.00
EIVH38 1.00
EIVK38 1.00
000000082585 EIRH69 1.00
EIRK69 1.00

the first 3 items in column B belongs to the first item in column a.
Accordingly the next 2 items in col "b" belongs to the next item in col "A".
I want to number the first item in col "A" as 1 and the 3 items in col "B" as
1.1, 1.2 1.3 and accordingly, the next item in col "a" as number 2 and
accordingly the item 4 and 5 in col "b" as 2.1 & 2.2 and so on.....

Number them where?

Using a Macro?

--
Regards,
Tom Ogilvy


"Dev" wrote:

> Please see the data below
>
> a b c
> 000000080672 EI0G18 1.00
> EIVH38 1.00
> EIVK38 1.00
> 000000082585 EIRH69 1.00
> EIRK69 1.00
>
> the first 3 items in column B belongs to the first item in column a.
> Accordingly the next 2 items in col "b" belongs to the next item in col "A".
> I want to number the first item in col "A" as 1 and the 3 items in col "B" as
> 1.1, 1.2 1.3 and accordingly, the next item in col "a" as number 2 and
> accordingly the item 4 and 5 in col "b" as 2.1 & 2.2 and so on.....

Number them where?

Using a Macro?

--
Regards,
Tom Ogilvy


"Dev" wrote:

> Please see the data below
>
> a b c
> 000000080672 EI0G18 1.00
> EIVH38 1.00
> EIVK38 1.00
> 000000082585 EIRH69 1.00
> EIRK69 1.00
>
> the first 3 items in column B belongs to the first item in column a.
> Accordingly the next 2 items in col "b" belongs to the next item in col "A".
> I want to number the first item in col "A" as 1 and the 3 items in col "B" as
> 1.1, 1.2 1.3 and accordingly, the next item in col "a" as number 2 and
> accordingly the item 4 and 5 in col "b" as 2.1 & 2.2 and so on.....

Is there a way to number them in col "D".

"Dev" wrote:

> Please see the data below
>
> a b c
> 000000080672 EI0G18 1.00
> EIVH38 1.00
> EIVK38 1.00
> 000000082585 EIRH69 1.00
> EIRK69 1.00
>
> the first 3 items in column B belongs to the first item in column a.
> Accordingly the next 2 items in col "b" belongs to the next item in col "A".
> I want to number the first item in col "A" as 1 and the 3 items in col "B" as
> 1.1, 1.2 1.3 and accordingly, the next item in col "a" as number 2 and
> accordingly the item 4 and 5 in col "b" as 2.1 & 2.2 and so on.....

Sub number_items()
Dim imajor As Long, iminor As Long
Dim rng As Range, cell As Range
imajor = 0
iminor = 0
Set rng = Range(Cells(1, "B"), _
Cells(Rows.Count, "B").End(xlUp))
For Each cell In rng
If Not IsEmpty(cell.Offset(0, -1)) Then
imajor = imajor + 1
iminor = 1
End If
cell.Offset(0, 2).Value = "'" & imajor _
& "." & iminor
iminor = iminor + 1
Next
End Sub

Test this on a copy of your data. I assume the 1.0 are in column C. and
column a has some blank cells in it (your labels in the post are a little
off).

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote:

> Number them where?
>
> Using a Macro?
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Dev" wrote:
>
> > Please see the data below
> >
> > a b c
> > 000000080672 EI0G18 1.00
> > EIVH38 1.00
> > EIVK38 1.00
> > 000000082585 EIRH69 1.00
> > EIRK69 1.00
> >
> > the first 3 items in column B belongs to the first item in column a.
> > Accordingly the next 2 items in col "b" belongs to the next item in col "A".
> > I want to number the first item in col "A" as 1 and the 3 items in col "B" as
> > 1.1, 1.2 1.3 and accordingly, the next item in col "a" as number 2 and
> > accordingly the item 4 and 5 in col "b" as 2.1 & 2.2 and so on.....

Using Formulas it Would look something like this:
Columns D
=IF(ROW()=2;1;IF(A2<>"";D1+1;D1))
Column E
= IF(ROW()=2;1;E1+1)
Column F
= D2&"."&E2