Automatically number rows in Excel according the dates in column B

Malavika P

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.

What I am getting, which wont work for my needs

But I would like to get the following results, just by dragging from the top column.

What I need, numbering according to new dates in column B

Jos Woolley

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.

edited at
0

Comments

0 comments
Login to comment

Related

Dates according to the number of days

Excel: Split a 2 column range (A:B) into multiple smaller columns with a pre-set number of rows

Automatically adding a link on column B to a string in column A in Excel

Find number of rows in an already filtered Column A in Excel

Using xlsx in Angular - How to make excel identify the dates as actual dates in column automatically?

Microsoft Excel how do I convert the first row into column and then sort the rest of the rows according to the first column

Duplicate rows, according to value in a column

Merge rows if Column A, B, and C all match (Excel)?

Excel - Averageifs and excluding data range according to dates

Openpyxl : need the max number of rows in a column that has data in Excel

Read Excel with varying number of rows per column to dataframe without NAN

Excel 2016 - Find matching rows in column b, then sum Column C copy sum in Next Sheet Column A

Excel: If name in column A matches name in column B, then count number of times text "on time" is present in column C

Excel: Summing a column according to values in another column

Counting the number of rows which have column a = x, and column b = y, (groupby, value_count)

Count number of rows in column A that have a value in a list in column B on worksheet 2

Sort matrix according to number of non zero rows

Row_Number() partitioning according to consecutive rows

How to number rows according to values in columns

Split a dataframe according to priorities and specific number of rows

Limit the number of rows in Excel

Number values for dates wrong in excel?

Pandas split rows according to column condition

Replicating rows in Spark dataframe according values in a column

R: Filtering rows of a factor according to a column

Align several rows according to vertical column

average column rows according to value in other columns

How to query duplicated rows according to column value?

Display column values in rows according to index