View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cynthiabryant
 
Posts: n/a
Default group counter in excell

I need to apply a incremental number by group of data. if I have
18 29TH ST 1

18 29TH ST 1
0 MARGARET ST 2
0 MARGARET ST 2
0 OLD PENZANCE RD
0 ZIG ZAG ALY 3
0 ZIG ZAG ALY 3

I need to return the following
18 29TH ST 1

18 29TH ST 1
0 MARGARET ST 2
0 MARGARET ST 2
0 OLD PENZANCE RD
0 ZIG ZAG ALY 3
0 ZIG ZAG ALY 3

based on the duplication of the records