finding distinct values from two lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one columns with a list of dintinct values and a second column with a list of distinct values. How do I get a distinct list from columns one and two

Exampl
Column A Column B Column C Column
Jeff 100 Ralph 40
Paul 500 Jeff 10
Mary 600 Paul 30

How do I get the distinct values in column's A and C? Can I even get the values from the two lists lined up
Jeff 100 10
Paul 500 30
Mary 60
Ralph 40

Thanks in advance
 
Hi
one way: try the following (using pivot tables):
- copy column A + B to a separate sheet (lets say 'sheet2')
- in C1 enter a description for these values (e.g. 'Data1'). copy this
down for all values from col A+B
- copy column C+D from the first sheet directly below the values from
col A+B. In column C enter 'data2' for these values
- Add a heading row (e.g. Name - Value - Datasource). the result should
look like:
A B C
Name Value Datasource
Jeff 100 data1
Paul 500 data1
....
Ralph 400 data2
....

select this range and use a pivot table ('Data - Pivot table). Use
'Name' as row and 'Datasource' as column in this pivottable. Sum of
'Value' will be your data field. this will result in something like
data1 data2
Jeff 100 100
....

For more information about pivot tables have a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm


Frank
 
Back
Top