My Online Training Hub

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

Reset sequence # when running total = 0|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Reset sequence # when running total = 0|General Excel Questions & Answers|Excel Forum|My Online Training Hub

office scripts course

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
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
Reset sequence # when running total = 0
Avatar
Kasey Morris
Member
Members
Level 0
Forum Posts: 7
Member Since:
April 6, 2022
sp_UserOfflineSmall Offline
1
February 24, 2023 - 1:33 am
sp_Permalink sp_Print

Hi

 

In attached I need to add 2 columns

Running total - contains an error value (why is it an error? as it is a simple formula)

Sequence - number to reset when Running total = 0

 

Many thanks

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1548
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
February 24, 2023 - 8:58 am
sp_Permalink sp_Print

Hi Kasey,

Nothing attached.  Click Start Upload after selecting the file(s).

Phil

upload fileImage Enlarger

Avatar
Kasey Morris
Member
Members
Level 0
Forum Posts: 7
Member Since:
April 6, 2022
sp_UserOfflineSmall Offline
3
February 24, 2023 - 10:42 pm
sp_Permalink sp_Print

Ooops! Thanks Philip

 

Now attached 

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members


Trusted Members

Moderators

Power BI
Level 1
Forum Posts: 587
Member Since:
January 31, 2022
sp_UserOfflineSmall Offline
4
February 24, 2023 - 11:42 pm
sp_Permalink sp_Print

The number -1.4210854715202E-14 is not an error. It's just a very very small number, very close to zero. Change the format of column F to Number with three decimals and you'll get 0.000 in F20.

Avatar
Kasey Morris
Member
Members
Level 0
Forum Posts: 7
Member Since:
April 6, 2022
sp_UserOfflineSmall Offline
5
February 28, 2023 - 8:41 pm
sp_Permalink sp_Print

Hi

I am reposting this topic as I forgot to attached doc 

Please see attached

 

How do I add insert a formula (Sequence column) which will give the answers I have typed. The value will reset when running total = 0

 

Much appreciated.

Avatar
Bjarnehansen

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
May 7, 2017
sp_UserOfflineSmall Offline
6
February 28, 2023 - 11:20 pm
sp_Permalink sp_Print sp_EditHistory

like this

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Cindy Walawander, tre lewis, Earl Tuckman, Rob Starren, Leigh Thomas
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
QSolutions Group
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28549

 

Member Stats:
Guest Posters: 49
Members: 32803
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen