Hi,
I have sample sales data as in A1:AZ7 in the screenshot below.
I would like to create a formula that, for each Product Code, returns the country associated with a value that isn't "-" and is closest in position to the last column in the range.
In my example, Germany would be extracted against AAA and Italy for BBB.
Can someone please suggest a formula to achieve this?
Thanks!
PS the dates in row 1 are text, not numbers
I have sample sales data as in A1:AZ7 in the screenshot below.
I would like to create a formula that, for each Product Code, returns the country associated with a value that isn't "-" and is closest in position to the last column in the range.
In my example, Germany would be extracted against AAA and Italy for BBB.
Can someone please suggest a formula to achieve this?
Thanks!
PS the dates in row 1 are text, not numbers