6 cells into 1

[Guest]

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

 

[Guest]

Oh.. I also need to keep the cells background color...

 

[Frank Kabel]

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

 

[Frank Kabel]

Hi
keeping the color is not possible with formulas!

 

[Guest]

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]

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

 

[Guest]

Thanks frank,
when I do the filter to get the colors I can add a code instead of colors
and after the vlookup do a find and color from thier should work great...
thanks again..