Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |