Point one seems to remedied by modifying the formula in E8 and down so that it reads:
Formula:
=IF(AND(D8="",H8=""),"",IF(ISNA(VLOOKUP(D8,FABDUPLIST,2,FALSE)),E7,(VLOOKUP(D8,FABDUPLIST,2,FALSE))))
Point one seems to remedied by modifying the array entered formula in G8 and down so that it reads:
Formula:
=IF(D8="","",SUM(INDEX($H$8:$H$101,MATCH("zzzzz",$E$8:E8,1)):INDEX($H$8:$H$101,MATCH("zzzzz",$E$8:E8,1)-1+INDEX(FREQUENCY(IF($H$8:$H$101,ROW($H$8:$H$101)),IF(NOT($H$8:$H$101),ROW($H$8:$H$101))),COUNTIF($H$7:H7,"")))))
Let us know if you have any questions.
Bookmarks