Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with differents conditions
I need the formula to combine in cell "I 1", data from more
than 2 cells in column "A", when cells from columns "F and/or G" MATCH data in cells from column "H", only IF column "B" is =1. Example "I1, I2, I3, etc" A B C D E F G H I WSt USA Ch Srv Ob LHD TD TL USA 1 100 1 30 24 24 100, 103 2 101 1 33 30 100, 102, 105 3 102 1 30 33 101, 103 4 103 1 33 24 50 105 5 104 1 84 85 74 6 105 1 30 50 84 7 106 1 33 24 85 -- When it commes to machinning, I am the BEST |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with differents conditions
I don't follow your logic to arrive at the numbers you have in Column I.
Explain each number and why it should be where it is. HTH Otto "JMALTO" wrote in message ... I need the formula to combine in cell "I 1", data from more than 2 cells in column "A", when cells from columns "F and/or G" MATCH data in cells from column "H", only IF column "B" is =1. Example "I1, I2, I3, etc" A B C D E F G H I WSt USA Ch Srv Ob LHD TD TL USA 1 100 1 30 24 24 100, 103 2 101 1 33 30 100, 102, 105 3 102 1 30 33 101, 103 4 103 1 33 24 50 105 5 104 1 84 85 74 6 105 1 30 50 84 7 106 1 33 24 85 -- When it commes to machinning, I am the BEST |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with differents conditions
Thanks for your respond.
For instant, in H1 I have "24", then every time that finds a match in column "F or G" and "IF" column "B" the corresponding row value is "1", then I pull the corresponding data from column "A". The answer for that, will be I 1 =Match(H1 within F or G columns AND IF B column =1, A1:A7) "Otto Moehrbach" wrote: I don't follow your logic to arrive at the numbers you have in Column I. Explain each number and why it should be where it is. HTH Otto "JMALTO" wrote in message ... I need the formula to combine in cell "I 1", data from more than 2 cells in column "A", when cells from columns "F and/or G" MATCH data in cells from column "H", only IF column "B" is =1. Example "I1, I2, I3, etc" A B C D E F G H I WSt USA Ch Srv Ob LHD TD TL USA 1 100 1 30 24 24 100, 103 2 101 1 33 30 100, 102, 105 3 102 1 30 33 101, 103 4 103 1 33 24 50 105 5 104 1 84 85 74 6 105 1 30 50 84 7 106 1 33 24 85 -- When it commes to machinning, I am the BEST |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with differents conditions
I've posted one crack at it in your latest re-post
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "JMALTO" wrote: Thanks for your respond. For instant, in H1 I have "24", then every time that finds a match in column "F or G" and "IF" column "B" the corresponding row value is "1", then I pull the corresponding data from column "A". The answer for that, will be I 1 =Match(H1 within F or G columns AND IF B column =1, A1:A7) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
mulitple concatenate conditions | New Users to Excel | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Excel in differents idioms | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |