counting unique values and matching to quantities
I have a situation where I need to pull information out of a
spreadsheet and consolidate it into groups of unique values. In this
case, one column indicates a specifc length (in feet) and another
indicates the quantities of those lengths (ie: 5 pieces @ 3 feet).
Right now, I am using the COUNTIF function to pull out what the unique
lengths are but I cannot figure out a way to correlate them to their
respective quantities.
Can somebody point me in the right direction?
Thanks a bunch...
|