Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest value in Col B for each unique value in col A
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest value in Col B for each unique value in col 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 "calibansfolly" wrote in message oups.com... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest value in Col B for each unique value in col A
This works. Is there a way then to sort these, or delete or hide the
rows that aren't red? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest value in Col B for each unique value in col A
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 "calibansfolly" wrote in message oups.com... This works. Is there a way then to sort these, or delete or hide the rows that aren't red? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest value in Col B for each unique value in col A
This is perfect- thanks, Bernie!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Count the largest | Excel Discussion (Misc queries) | |||
Largest Value | Excel Worksheet Functions | |||
Second largest value | Excel Discussion (Misc queries) | |||
Help with finding largest value | Excel Worksheet Functions |