You can use this array* formula

=IF(B1=MAX(IF(A:A=A1,B:B)),1,"")

Copy down column C as needed.
*Use Ctrl+Shift+Enter to confirm formula, not just Enter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Secret Squirrel" wrote:

I have 2 columns, column A for my quote # and column B for the quantity. What
I want to do is find the largest qty in column B for a particular quote # in
column A. The quote # will be listed more than once.

Column A Column B
12345 1000
12345 1500
12345 2000

So in column C I want to put a "1" where it finds the largest quantity for
that quote #. So in the above example there would be a "1" in column C, Row 3.

How would I write this formula?