Thread
:
Please help with summative column (VLOOKUP???)
View Single Post
#
4
Posted to microsoft.public.excel.programming
excelent
external usenet poster
Posts: 695
Please help with summative column (VLOOKUP???)
P2=IF(COUNTIF(H2:$H$2000,H2)=1,H2,""
Q2=IF(ISERROR(VLOKUP(L2,$H$2:$I$2000,2,FALSE)),"", VLOOKUP(L2,$H$2:$I$2000,2,FALSE))
R2=SUMPRODUCT(($H$2:$H$2000=L2)*($J$2:$J$2000))
Insert and copy down 2000 rows
Reply With Quote
excelent
View Public Profile
Find all posts by excelent
Please help with summative column (VLOOKUP???)