Originally Posted by
Pete_UK
Put this formula in cell D2:
=IF(AND(SUMIF($A$2:$A$19,A2,$C$2:$C$19)>=1000,COUNTIF(A$2:A2,A2)=1),MAX(D$1:D1)+1,"-")
then copy down to the bottom of your data.
Then you can use this formula in cell F2 (say):
=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),D:D,0)),"")
and copy down until you start to get blanks to give you a list of the account numbers with deposits of 1000 $ or above. If you want to know the actual deposits for those accounts, you can put this formula in G2:
=SUMIF($A$2:$A$19,F2,$C$2:$C$19)
and copy this down.
Hope this helps.
Pete
Bookmarks