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
|