Automatically adding serial numbers in Excel is easy, but I would like to know if there is an easier way to add serial numbers only columns near new dates. I simple works, want to add serial numbers to each days, without any counting duplicates. Each date should be counted only once.
I am only able to achieve the following.
But I would like to get the following results, just by dragging from the top column.
Assuming the No. header is in A1
, in A2
:
=IF(B2<>B1,MAX(A$1:A1)+1,"")
and copied down.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments