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