$2,000. Using the above example, if a user had selected Person A, the result would be: 3 (the 2 x orange font lines for Account 1, the 2 x blue font lines above for Account 2 and the 1 x red font line above for Account 3). .">
Most valuable professional
  • Hot Topics

Excel Complex Unique Count - Is This Possible?

Hi All, I'm ideally looking for a one-cell solution, happy with a formula or VBA function (it needs to be able to update as the background data updates though). I have a data set in the background similar to the below (assume "Name" is in Cell A1): Name Person A Person A Person A Person A Person A Person A Person A Person B Person B Person B Person B Person B Person B Person B (The above would be updated on a monthly basis; it would remain in the same format, but the values and the number of rows would change.) There is then a separate worksheet, which contains a data validation drop-down, allowing a user to select a "Name". I need to be able to calculate the unique number of Accounts, linked to that selected Name, which have total sales for Group 1 >$2,000. Using the above example, if a user had selected Person A, the result would be: 3 (the 2 x orange font lines for Account 1, the 2 x blue font lines above for Account 2 and the 1 x red font line above for Account 3).

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of October 7, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel