Auto fill in sequence numbering on a filtered data MS Excel and LibreOffice Calc spreadsheet

Formula with function AGGREGATE wich auto fill in sequence numbering on a filtered data excel spreadsheet in programs MS Excel and LibreOffice Calc.

[mikachan]

Thanks a lot, been wondering for a long time if this actually possible, and now i found your video. ❤❤❤

[JP-hzzb]

So many complicated/wrong solutions out there, but this one works - thank you!

[toyinayebiwo]

Thanks a lot for this. What a time saving exposure.

[ricardoribeiroolivetti]

Thanks, it worked! greetings from Brazil.

[tttaker]

very very nice...i was looking exactly for this...

[rayan_alsharabi]

It didn't work in google sheets, is there a way to work

[m_faiz]

Thanks Sir.
How to numbering on filter data
Kindly help me

[humikhan]

Yay formula phaly work krta tha ab q nibkrta