How to Give Duplicate Values the Same Serial Number in Excel
If you have a list where the same value repeats, you may want every occurrence of that value to carry the same serial number, no matter where it shows up in the list. A regular 1, 2, 3 fill won’t do this, because it gives every row a different number. But it’s simple to fix …
