Find Max # in zip code range and then sum all numbers in that zip code

In D5:

=MAX(INDEX($C$5:$C$13*($A$5:$A$13=A5),0))

And in E5:

=SUMIF($A$5:$A$13,A5,$C$5:$C$13)

Copied down.

This works, but can we add a True / False result in the Max(Index formula so I can filter on the "True" results?

Marvin,

Not really because I need to be able to quickly filter my list and delete the rows I no longer need. The max(index formula is really close to what I need, but instead of a numeric result I need a true or a false. Is that possible?

=MAX(INDEX($C$5:$C$13*($A$5:$A$13=A5),0))

Thanks for both of your help, I really appreciate it!

I added in a third column that has an OR(EXACT formula to tell me whether or not my Max(Index result matches my original Zip Code amount, if the answer is False, I can filter those out. This is a work around that would work, but I"m wondering how to edit the Max(Index to just include it? For some reason the thread won't let me attach the file, but here's the formula:= OR(EXACT(D5,C5))

So, rather than showing the MAX result you just want to know if each row equals the max result?

=A5=MAX(INDEX($C$5:$C$13*($A$5:$A$13=A5),0))

Here is what I typed: =A5=MAX(INDEX($C$5:$C$13*($A$5:$A$13=A5),0))

I'm getting False results for every Zip.

Sorry, sorry, my fault:

=C5=MAX(INDEX($C$5:$C$13*($A$5:$A$13=A5),0))

Woot! Yes, that's perfect!! Thank you! :D