Hi
my formula would always take the last entry so it should work for you.
But as stated in the other response: No chance to get the color as well

--
Regards
Frank Kabel
Frankfurt, Germany

"Duncan_J" schrieb im Newsbeitrag
...
Hi Fank,
Sometimes thier are 2 per row... it's like a sequence, start is 1
begin is
2... if start and begin are on the same row I take the later which
would be
begin...
Thanks... Oh and they have to retain thier colored background..


"Frank Kabel" wrote:

Hi
do you only have one entry per row or if not what should happen if
you
have more than one entry in a row?

For only one entry try the following formula in S1:
=LOOKUP(REPT("Z",255),M1:R1)
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany

"Duncan_J" schrieb im
Newsbeitrag
...
Hi folks...
I'm going to try this again...
M N O P Q R S
1 Start
Start
2 Run
Run
3 Finish
Finish
4 Start
Start
5 Finish
Finish
6 Done
Done
ect...

I do a vlookup for one at a time Coulmns M-R and only 1 out of
the 6
lookups
will find data. I need to disregard the blank cells and copy the
data
to of
the populated cells to coulmn S
Thanks for the help,
DJ