Re: 6 cells into 1

From: Duncan_J (DuncanJ_at_discussions.microsoft.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 09:54:02 -0800

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" <DuncanJ@discussions.microsoft.com> schrieb im Newsbeitrag
> news:721D8952-FC7C-4887-928C-AC9E1B2399A9@microsoft.com...
> > 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
>
>