Largest value in Col B for each unique value in col A

  • Thread starter Thread starter calibansfolly
  • Start date Start date
C

calibansfolly

Column A has a series of customer numbers and column B has each
contribution from that customer. Is there a way to somehow mark the
largest value in column B for each unique value in column A?
 
Select all the cells in column B - Let's assume that B2 is the first of your actual data cells -
then use Format / Conditional Formatting... Select the "Formula is" option, and use the formula

=MAX(($A$2:$A$XXX=A2)*$B$2:$B$XXX)=B2

replacing the XXX with the row number of your bottom-most entry. Then set the formatting to a red
background, for example.

HTH,
Bernie
MS Excel MVP
 
This works. Is there a way then to sort these, or delete or hide the
rows that aren't red?
 
Use the same formula in another column and then use Data Filters to show
only TRUE values. But you will need to use Ctrl-Shift-Enter instead of just
enter when you use that formula in a cell.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top