| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
6 cells into 1
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
Oh.. I also need to keep the cells background color...
"Duncan_J" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
Hi
keeping the color is not possible with formulas! -- Regards Frank Kabel Frankfurt, Germany "Duncan_J" schrieb im Newsbeitrag ... Oh.. I also need to keep the cells background color... "Duncan_J" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
6 cells into 1
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.. "Frank Kabel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Linear Mode
