Formula to produce similar results as a pivot table.

[Brian]

I have a table (approx 600 lines) of sales persons initials in one column and another column with tons sold for each sales person. I would like a formula that would look through all 600 lines and provide just one output reference for each person.

' A

Sales

1 EJM

2 JB2

3 EJM

4 DLL

5 DLL

6 EJM

7 DLL

8 JB2

9 DLL

10 DLL

11 EJM

12 EJM

13 DLL

14 DLL '


Result example:

DLL

EJM

JB2


Once I have this , I can then use , say, sumproduct, to get the sum of tons sold by each sales person.

Thank you.


You have an awesome site and have helped me so much before. I am so grateful for all your efforts and help.

 

[NARAYANK991]

Hi Brian ,


You should get the answer from here :


http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/


Narayan