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?