Find Last instance colum A and return corresponding B Value
Hi
I have two columns of data one with numbers (columnA) and the other with Y or N (column b)
What I'd like to do is find the last instance of a number in column A and return the corresponding B value. Column A value can appear any number of times.
e.g
Column A Column B
100 N
101 N
101 Y
102 N
103 N
103 N
103 Y
104 N
104 Y
Essentially for each of 100,101,102 etc I want to look at the last instance of it in column A and return to my secified cell what the corresponding B value is
All help appreciated.
Thanks
Will.
|