Quote:
Originally Posted by blivy
Okay so I thought about an alternative but I still need a bit of help. I thought about using a vlookup in combination so I have something along the lines of this:
ABER AM AB145-------ABER AM 5
ABER AM AB145-------ABER AM 4
ABER AM AB250-------ABER AM 3
ABER AM AB250-------ABER AM 5
ABER AM AB35--------ABER AM 3
AER 132--------------AER 2
AER 234--------------AER 2
AER 235--------------AER 1
etc.
But how could you create a graph that would combine the cells with the same name so that I would just have
ABER AM 20
AER 5
in a bar chart?
Thanks.
|
If you're using Excel 2007 or later you can use countifs to do this. If 2003 or earlier you can use sumproduct. Far easier than array formulas...
To show you exactly how I would need to see an example workbook.