Hi,
I have a bunch of data, for example;
A1: J3000
Column C has the account number which repeats multiple times.
I'm using the =SUMPRODUCT function to pull information I need in a summary table.
The problem:
I have to manually put in the account numbers in the summary table, as I only want them to come up 1X.
I would like the summary table to get the Account Number in column C then use the "=SumProduct" function to pull the data (which I can do).
How can I do that.
Thanks for your help.
Jason
Last edited by jpnyc; 06-24-2011 at 02:49 PM.
use advanced filter to extract an uniqe list of account numbers
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thanks
Ok - I was taking the whole range which was not working.
If I just take the column I want - it works.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks