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

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?
 
B

Bernie Deitrick

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
 
C

calibansfolly

This works. Is there a way then to sort these, or delete or hide the
rows that aren't red?
 
B

Bernie Deitrick

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

Similar Threads

Criteria to return maximum value where x = x 3
Finding the largest match 9
Formula (or code) return the largest number of duplicates in a list. 16
Find largest value in column with 2 criteria 1
Return the value from one range that does not exist in another 0
What excel function to use? 1
vlookup against one of two options? 3
compare and return a value from another worksheet 3

Top