Adding information to a column

[BarbaraDH]

I have 4 columns of information. At the row above column A is an identifying Name for that section of the spreadsheet. After every 100 or so rows there is a new identifying Name in column A. I want to insert that identifying number in a new column to the right of column A and have the number change everytime a new identifying Name appears in column A, so that I can sort by the part number
Example:

Salesclerk 1 = Identifying Number
Column A has part numbers for items sold
Column B is where I want to put Salesclerk 1 in each row until Salesclerk 2's sales start
Column C has the number of sales made of the part number that is listed in Column A.

Salesclerk 1
pn23456 32
pn49857 35
pn67899 46

Salesclerk 2
pn23456 37
pn49857 32
pn67899 41

 

[just_jon]

Getting ready to go for the evening, but does each PN row begin with "pn"?

 

[BarbaraDH]

No, but each Heading starts with the word sales clerk

 

[Yogi Anand]

Hi Barbara:

One formula based approach ...

y040129h1a.xls
	A	B	C	D
1	Salesclerk1		<-blank
2	pn2345632	Salesclerk1
3	pn4985735	Salesclerk1
4	pn6789946	Salesclerk1
5
6	Salesclerk2
7	pn2345637	Salesclerk2
8	pn4985732	Salesclerk2
9	pn6789941	Salesclerk2
10
11	Salesclerk3
12	pn2345651	Salesclerk3
13	pn2345652	Salesclerk3
Sheet9

I have made no attemp to simplify the formula -- but this should get us started.

Would this do?

 

[BarbaraDH]

Thank you.

 

[Yogi Anand]

Hi Barbara:

You Are Welcome -- and let us know if you need to simplify the formula or if you need to discuss any thing further on this!