Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2019, 11:57 PM
yande yande is offline Stock Balance by item and date Windows 10 Stock Balance by item and date Office 2016
Novice
Stock Balance by item and date
 
Join Date: Oct 2019
Posts: 2
yande is on a distinguished road
Default Stock Balance by item and date

Hi master,

This issue i'd post on chandoo.org but i haven't receive the latest reply for this issue.
So just want to seek for help in this forum, hope it will might help me.
This is the link for my post 'Bring Forward' stock formula in excel | Chandoo.org Excel Forums - Become Awesome in Excel

I don't know how to create a formula in excel to get an actual balance of stock referring the date and selected item.


The balance of pencil on 2nd jan is 100, because on 1st jan got in-stock 100.
Balance of the pencil on 20th apr is70, because at 4th and 19th feb there's deduction of 20 and 10.


Please help me. tq in advance.
Attached Files
File Type: xlsx EXAMPLE.xlsx (9.7 KB, 6 views)
Reply With Quote
  #2  
Old 10-16-2019, 03:05 AM
ArviLaanemets ArviLaanemets is offline Stock Balance by item and date Windows 8 Stock Balance by item and date Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

A possible solution on added sheets
Attached Files
File Type: xlsx EditedEXAMPLE.xlsx (15.8 KB, 10 views)
Reply With Quote
  #3  
Old 10-16-2019, 06:38 AM
yande yande is offline Stock Balance by item and date Windows 10 Stock Balance by item and date Office 2016
Novice
Stock Balance by item and date
 
Join Date: Oct 2019
Posts: 2
yande is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
A possible solution on added sheets
Million thanks! You are awesome!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep balance column empty if no amount entered baes10 Excel 3 08-14-2018 06:31 AM
Stock Balance by item and date Copying data related to one item to worksheet with many instances of the same item nmp13 Excel 3 02-06-2016 02:13 AM
Don't Balance Columns for Continuous Section Starts titani2 Word 1 01-25-2015 01:11 PM
How to know the outstanding balance amount of a Loan? PRADEEPB270 Excel 1 01-07-2012 04:45 AM
Balance from different sheets andre Excel 0 11-29-2011 02:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft