combination of countif/sumif should do the trick
in O5
Formula:
=IF(COUNTIF($B$5:B5,B5)=0,"",IF(COUNTIF($B$5:B5,B5)=COUNTIF(B:B,B5),COUNTIF($B$5:B5,B5),""))
in p5
Formula:=IF(O5="","",SUMIFS(H:H,B:B,B5))
in column Q
not quite sure the logic is but the formula in there doesnt seem to work on certain lines
Last edited by humdingaling; 12-20-2017 at 12:21 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks