E
Eric H
I have a monthly list of Selling Prices by part that I want to use a formula
on to retrieve the most recent price. The problem occurs when the last
month(s) in the list has no sales and thus no sellng price. See Below:
Sep Oct Nov Dec
Part A 4 4 4 3
Part B 2 2
I can't use 12 If Statements to say "If Dec is 0, use Nov, If Nov is 0 use
Oct, etc". What formula can I use that will go backwards (In this case Dec
backwards) until it finds a value?
on to retrieve the most recent price. The problem occurs when the last
month(s) in the list has no sales and thus no sellng price. See Below:
Sep Oct Nov Dec
Part A 4 4 4 3
Part B 2 2
I can't use 12 If Statements to say "If Dec is 0, use Nov, If Nov is 0 use
Oct, etc". What formula can I use that will go backwards (In this case Dec
backwards) until it finds a value?