=MAX(SUMPRODUCT(($A$1:$A$8=A1)*($C$1:$C$8)),SUMPRODUCT(($A$1:$A$8=A1)*($D$1:$D$8)))
Copy down as needed
=MAX(SUMPRODUCT(($A$1:$A$8=A1)*($C$1:$C$8)),SUMPRODUCT(($A$1:$A$8=A1)*($D$1:$D$8)))
Copy down as needed
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks