I have a column of data - example below. The content of this column stays the
same each day but the amount of each value changes. Therefore tomorrow, there
could be 3 cells containing apple, and 10 containing banana.
I want to write something, whereby I can write in banana and the cursor will
go to the last cell in which the word banana (or any of the other fruit) is
located. Any ideas??

apple
apple
banana
banana
banana
orange
orange