Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please, need help, I have to prepare a report today.
I need a formula that combines data from 2 or more
cells from column "A", when cells from columns "F and/or G" MATCH data in cells from column "H", and 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 Just human |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prepare a report | Excel Discussion (Misc queries) | |||
how to prepare formulae | Excel Worksheet Functions | |||
How do I prepare a allowance payment tracker? | Excel Discussion (Misc queries) | |||
HOW TO PREPARE SUMMARY OF DIFFERENT ITEMS IN ANOTHER WORKSHEET? | Excel Worksheet Functions | |||
=IF(OR(TODAY() |
Excel Discussion (Misc queries) |