Position within group based on ascending sorted date column


Here is a table without any sorting:

formula for Position Within Group:

I need correct looking column(Position within group) based on ascending sorted date column:

Help me please!

Here are some related topics:

Here is the doc:


I added a yellow column to your doc. Is this what you’re after? Try un-sorting and re-sorting the date column and watch what happens to the values in the yellow column.

1 Like

@Ander Thanks a lot! The solution was easier than I thought :laughing: :smiley:

1 Like