Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the out put from different cells
You guys have helped me out alot, now here's another one for yall !!
a b c d 1 j1 50 12 30 2 j2 42 15 0 3 j3 46 14 0 4 j4 50 17 0 the output that im looking for would be this : j1 quantity 2 12,17,30 j2 quantity 1 15 j3 quantity 1 14 basically, i want to : 1) find all the same numbers in column in column b 2) add the quantity of exact matches together 3) and then display the assoisacted numbers from columns c and d (no math to these numbers...they must stay the same...see above) Can this be done ? Thanks for everything !! EBnLP01 |
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 | |||
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 | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |