Share via

running total by nearest group in Excel

Runner 41 Reputation points
2021-08-19T15:12:32.9+00:00

124772-running-total-by-nearest-group.png

Hello
is it possible in excel create running total by nearest group like in image.
Thanks

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,368 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,940 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2021-08-20T07:15:46.277+00:00

    Hi @Runner ,
    Try this formula: 

    =B2+IF(A2<>A1,0,C1)

    124971-461.png

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.