slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hi All,
Been away from excel for a while and very rusty with Sumproduct so im trying to get help with the following example to help me with a list problem.
I have two lists. Im extracting data from the second list to add to the first list.
both lists have the company name as the join. The second list has multiple people for each customer I need to list these in seperate columns on the first list. Each person has a identifer either 1 2 or 3 etc in the second list.
The Question do i use sumproduct or another function.
Been away from excel for a while and very rusty with Sumproduct so im trying to get help with the following example to help me with a list problem.
I have two lists. Im extracting data from the second list to add to the first list.
both lists have the company name as the join. The second list has multiple people for each customer I need to list these in seperate columns on the first list. Each person has a identifer either 1 2 or 3 etc in the second list.
The Question do i use sumproduct or another function.