+ Reply to Thread
Results 1 to 5 of 5

Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

  1. #1
    Forum Contributor
    Join Date
    01-25-2014
    Location
    Italy - Currently In USA
    MS-Off Ver
    Excel 2019
    Posts
    207

    Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

    Hello,
    I managed to work out this sample to calculate FIFO (First in First Out) It is working perfectly, thanks to Excel Forum

    I Want to change Column H inputs to "Buy" Rather than "Bought" and "Sell" rather than "Sold".
    When I replace the Word "Bought" in the sheet Module The formula in column Q no longer works and I get just 0 as a result.

    Could someone help me on this?

    I am not novice on Codes, But i can copy and Paste)

    Thank you In advance

    ONP
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

    Change the formula in L & M to Buy and Sell, as well!!!
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    01-25-2014
    Location
    Italy - Currently In USA
    MS-Off Ver
    Excel 2019
    Posts
    207

    Re: Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

    Hi Glen,
    Thank you for the Quick reply. My Bad on L & M

    Having done that the results are not the same as my original Sample.
    The results should be same as the Original Sample.
    Your corrected sample is not giving me correct results.

    Thank you
    Onp

  4. #4
    Forum Contributor
    Join Date
    01-25-2014
    Location
    Italy - Currently In USA
    MS-Off Ver
    Excel 2019
    Posts
    207

    Re: Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

    Ok Solved
    Maybe my coffee wasn't strong enough this morning.
    I had to change the values in N as well

    Thank you Glen

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Unable to Make FIFO Code work If I change text From "Bought" to "Buy"

    I need my coffee, too!!

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-19-2020, 08:30 PM
  2. How to make it work "='C:\Users\DK-01\Desktop\["& A1 &".xlsx]Sheet1'!$A$1"
    By london7871 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-10-2019, 09:06 PM
  3. [SOLVED] Make "WeekdayName" Function Work With "dd/mm/yyyy" Format
    By KMVKMVKMV in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2019, 02:30 PM
  4. Replies: 3
    Last Post: 07-07-2018, 01:12 AM
  5. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1