Hello,
Is it possible to set a formula to in column c to look at column A and if it has a value, go up to the last or previous blank cell, then go to column b and return the value and the corresponding row value. For example:
Column A Column B Fromula Result
<Blank> Dog
3 cat Dog Cat
6 Bird Dog Bird
<Blank> Cow
7 Snake Cow Snake
9 Horse Cow Horse
Thanks for the help!
Bookmarks