Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 14th 19, 08:00 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 2
Default Iterative Sum Calculation

Hello,

I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]

Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)

Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]

Stock used --- 80 units---Stock A(code 1+ Code 2)
Stock used --- 150 units---Stock A(code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks

Rakesh.K

  #2   Report Post  
Old May 14th 19, 08:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2016
Posts: 17
Default Iterative Sum Calculation

On Tuesday, 14 May 2019 08:00:24 UTC+1, wrote:
Hello,

I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]

Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)

Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]

Stock used --- 80 units---Stock A(code 1+ Code 2)
Stock used --- 150 units---Stock A(code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks

Rakesh.K


Hi

Create a table as below, and call it Stocks

A B C
Balance -20

Stock Code Units
A 1 250
A 1 -100
A 1 -100
A 1 -50
A 2 300
A 2 -30
A 2 -80
A 2 -150
A 2 -60

Name the
The formula in cell C2 should be =SUBTOTAL(109,Stocks[Units])

Then filter for Stock and code, and cell C2 will give the current balance



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterative Calculation [email protected] Excel Discussion (Misc queries) 0 May 14th 19 07:55 AM
Iterative Equation Chris Excel Discussion (Misc queries) 5 March 9th 10 01:32 AM
an iterative calculation -- sort of ali Excel Worksheet Functions 4 July 30th 09 07:57 PM
Iterative process, bioyyy Excel Discussion (Misc queries) 5 December 1st 05 02:07 AM
Iterative Macro Stuart Steven Excel Programming 7 July 14th 04 02:49 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017