i have table. some names of the first row are duplicated. i sort the names now i want to detect the first and last row number for the duplicated names.
sample1.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | count | forst row | last row | |||
2 | peter | 1 | 2 | 3 | ||
3 | peter | 1 | 2 | 3 | ||
4 | john | 2 | 4 | 4 | ||
5 | ali | 3 | 5 | 5 | ||
6 | mori | 4 | 6 | 8 | ||
7 | mori | 4 | 6 | 8 | ||
8 | mori | 4 | 6 | 8 | ||
9 | anderson | 5 | 9 | 9 | ||
10 | caroline | 6 | 10 | 10 | ||
11 | pele | 7 | 11 | 12 | ||
12 | pele | 7 | 11 | 12 | ||
Sheet1 |