Guys please help me with aging inventory formulas

Dear All,

i have problem with aging report formulas. could you guys help me. any kind of input really appreciate it much.



Thanks,

Blirey

Hi Blirey,

Perhaps if you could give us some examples of your expected outcome and explain how you got to those figures we could help provide a solution for you.

BSB.

Originally Posted by BadlySpelledBuoy

Hi Blirey,

Perhaps if you could give us some examples of your expected outcome and explain how you got to those figures we could help provide a solution for you.

BSB.

Hi BSB,

all i want is when we see the blue side in my spreadsheet ( download it from system) its only until >365 days.
the problem is i need to define it until 4 years (green side). and the total amount should be same with the green one.

can you help me on this, please.

Thanks

have a look at your formula in E9

it should be

Please Login or Register  to view this content.

you need to fix the cell references with $ so when you copy and paste it down the column those values won't change

i'm still looking at the other part of the problem, like

Please Login or Register  to view this content.

in G9 and copied pasted to column V and down

not sure at this stage is everything is doable with the info you've supplied

Originally Posted by ThirtyTwo

have a look at your formula in E9

it should be

Please Login or Register  to view this content.

you need to fix the cell references with $ so when you copy and paste it down the column those values won't change

i'm still looking at the other part of the problem, like

Please Login or Register  to view this content.

in G9 and copied pasted to column V and down

not sure at this stage is everything is doable with the info you've supplied

thanks i miss the vlookup one. but what realy need to is to fulfill the green one with the data from the blue one. need the formula to extract the number in column N into column V, W, X, Y but the total sum of H5:N5 must be same with sum of q5:y5