Hi Sarah

The following array formula will give you the address of the relevant
cell.
With fruits entered in D1:D8 and fruit required in F1

{=ADDRESS(MAX((D1:D8=F1)*ROW(D1:D8)),4)}

To commit or edit an array formula use Control + Shift + Enter (CSE)
instead of just Enter.
When you use CSE, Excel will include the curly braces { } . Do not
type them yourself.

--
Regards

Roger Govier


"Sarah" wrote in message
...
Hi
Thanks but not quite what I meant.
I need to automate it. i.e. I want to type banana in a specific cell
and
then the cursor to automatically move to the last cell in which banana
appears.

"Gary''s Student" wrote:

Edit Find and enter banana and select Find All

Then select the last entry on the presented list.
--
Gary's Student


"Sarah" wrote:

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