Comparison of data in two separate colunms
Thanks, I will give it a try!
"gchigo" wrote:
use pivot table. add materials to row and weight to data and do a sum
function on the data.
"thaenn" wrote:
In "Column AW" I have a list of material items (there are some that are the
same), and in "Column AX" I have the weight associated with each item.
My question is: How can I look up all "like items" in column AW and get a
total of the combined weight (for these like items)?
Thanks!
|