Need FIFO based Item ledger which could be able to in/out the stock in excel sheet

I

Imam

New Member
Joined
Nov 12, 2021
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
Hello,
I am new here and need urgent help.
Kindly share an excel sheet which could be able to Stock purchase and sale on FIFO basis rates automatically. Will be very thankful for the timely favor.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need help about FIFO Formula in excel sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
Please help. Need fifo based formula in this sheet for issue and purchases.
 

Attachments

  • FIFO NEED.png
    FIFO NEED.png
    77.2 KB · Views: 28
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
VBA Help- Need to create VBA Function from worksheet
Replies
9
Views
435
scotty1978
S
I
  • Locked
  • Question
Need Excel FIFO based Item Ledger
Replies
1
Views
326
Fluff
Fluff
A
  • Question
Lookup Help! Data table is dynamically dependent on data present in a row against which lookup is needed.
Replies
1
Views
371
asadriaz
A
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
930
Alex Blakenburg
A
A
  • Question
Excel VB Organogram
Replies
1
Views
70
anuradhagrewal
A

Forum statistics

Threads
1,214,409
Messages
6,119,339
Members
448,888
Latest member
Arle8907

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top