I have spent hours trying to figure this out with no success. I decided to turn to the experts.
I have a worksheet that has:
Column A has a unique record identifier, Column F has Parent Accounts (there are a lot of duplicates because a parent can be associated with a number of children), Column I has the total number of contacts per unique identifier. I need to look at each parent account and designate the one with the most contacts. In the example below, it would be line 11337. In column J, I concatenated the Parent Name with the Total separated by an "*" in one attempt to use FIND to try and find the maximum value for the parent (probably not the best approach). I could not get it to work for all 12,000 records. Using the right formula in a Conditional Formatting formula would be an approach, i.e. the MAX value for each parent would be formatted with a Yellow fill. Or, on a separate worksheet in the workbook, I could have a non-duplicating list of Parent accounts and have the unique identifier of the record with the MAX count of total contacts in a separate column, i.e. have the Parent in column A and the identifier in column B. I anxiously await the thinking of this august group as my brain is getting fried. I am sure one of you will have an "easy" solution that escapes me. Thanks in advance.
Example:
I have a worksheet that has:
Column A has a unique record identifier, Column F has Parent Accounts (there are a lot of duplicates because a parent can be associated with a number of children), Column I has the total number of contacts per unique identifier. I need to look at each parent account and designate the one with the most contacts. In the example below, it would be line 11337. In column J, I concatenated the Parent Name with the Total separated by an "*" in one attempt to use FIND to try and find the maximum value for the parent (probably not the best approach). I could not get it to work for all 12,000 records. Using the right formula in a Conditional Formatting formula would be an approach, i.e. the MAX value for each parent would be formatted with a Yellow fill. Or, on a separate worksheet in the workbook, I could have a non-duplicating list of Parent accounts and have the unique identifier of the record with the MAX count of total contacts in a separate column, i.e. have the Parent in column A and the identifier in column B. I anxiously await the thinking of this august group as my brain is getting fried. I am sure one of you will have an "easy" solution that escapes me. Thanks in advance.
Example: