Forum Discussion

ds100's avatar
ds100
Copper Contributor
Dec 28, 2021

How to Calculate LIFO with Dynamic Arrays

Hello All, I have a list of purchases and sales. In a new column, I would like to show the LIFO cost basis for each sales row.  Using the "Let" function, I started down this path by loading (i) the...
Formulas and Functions
mtarler's avatar
mtarler
Silver Contributor
Dec 29, 2021

ds100 I think a possible approach would be to use the sort and filter functions.  For example this will filter for only the Purchases and then sort in reverse order:

=SORT(FILTER(A3:D13,B3:B13="P",""),1,-1)

see attached

 

  • ds100's avatar
    ds100
    Copper Contributor
    Dec 29, 2021
    Thanks. We think alike.

Resources