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... |
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) |