C
ccclwilson
I am looking for help for a formula that will look at a set of values in
three columns and return the value of the last cell with data. Example
below. Hope this is not too vague.
col1 col2 col3 Result
1 1
1 2 2
1 3 3
If col1=1, return 1
If col1=1 and col2=2, return 2
If col1=1, col2=0 and col3=3, return 3
three columns and return the value of the last cell with data. Example
below. Hope this is not too vague.
col1 col2 col3 Result
1 1
1 2 2
1 3 3
If col1=1, return 1
If col1=1 and col2=2, return 2
If col1=1, col2=0 and col3=3, return 3