|
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 |
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 |
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 |
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 |
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 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 |
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 |
| All times are GMT +1. The time now is 07:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com