My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Number rows sequentially but ignore cells in range with text|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Number rows sequentially but ignore cells in range with text|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Number rows sequentially but ignore cells in range with text
Avatar
Josias Bolton

New Member
Members
Level 0
Forum Posts: 1
Member Since:
September 25, 2020
sp_UserOfflineSmall Offline
1
September 25, 2020 - 11:01 pm
sp_Permalink sp_Print

How can I number Column E so that the numbering follows sequentially after the "Break".
The user determines the position of the "Break" in A6 and A8. Should the position of the "Break" shift, then the numbering should adjust accordingly.

Columns G / H are examples of the desired outcome.

How can this be achieved without VBA?

Avatar
Purfleet
England
Member
Members


Trusted Members
Level 4
Forum Posts: 414
Member Since:
December 20, 2019
sp_UserOfflineSmall Offline
2
September 26, 2020 - 3:00 am
sp_Permalink sp_Print

I think thiis has the right concept, might need tweaking if you want the break before or after the number

=IF(D2=$C$5,$A$5,IF(D2=$C$7,$A$7,COUNTIFS($D$2:D2,"<>"&$C$5,$D$2:D2,"<>"&$C$7)))

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Vishal Nevase, John Kobiela, Sue Hammond, Lia Ro, Malcolm Sawyer
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6355
Posts: 27792

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen