Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
A very easy approach is to use a Pivot Table. Suppose your data looks like:
quan board length 5 3 8 3 2 2 Pull-down Data Pivot Table Report Let the Wizard guide you. Click Layout when this appears as an option. Drag board length to the Row area and quan to the Data area. Then click it to change Count to Sum. The following should result: board length Total 2 2 3 13 Grand Total 15 -- Gary''s Student " wrote: 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... |
#3
|
|||
|
|||
Hi!
It's not real clear what you're trying to do. Can you explain more? Biff wrote in message ups.com... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Matching unsorted lookup values | Excel Worksheet Functions | |||
Matching values from two columns and making a third column with the results - possible? | Excel Discussion (Misc queries) | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Matching a List Containing Redundant Values | Excel Discussion (Misc queries) |