Count Unique value from multiple sheet with criteria

On sheet 2, Advanced filter and check the unique box. Have the data placed into columns F & G. then in Sheet1, in B5 =COUNTIF(Sheet2!$F$2:$F$614,Sheet1!A5) and copy down.

Another way that uses dynamic named ranges (dnrs). If you are not familiar with dnrs they automatically size themselves to fit the data. Once they are set up formulas in the spreadsheet reference those dynamic ranges by their names.

There are two in the attached. These are formulas which are assigned names in Name Manager. They are Account_ID and Account_Owner_Alias

Their formulas are

	G	H
5	Account_ID	=Sheet2!$B$2:INDEX(Sheet2!$B:$B,MATCH("zzzzzz",Sheet2!$B:$B,1))
6	Account_Owner_Alias	=Sheet2!$A$2:INDEX(Sheet2!$A:$A,MATCH("zzzzz",Sheet2!$A:$A,1))

Then array enter this formula in B5 of Sheet1 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

You are welcome. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

As an alternative, have you attempted my solution?

Please find enclosed the Orginal File ( Please consider The Data Loader as Sheet 1 and Call Data as Sheet no 2)

In Dala Loader ShEet , I have a set of columns having the User IDs (Cell: E Column) ( expected outcome in Data Loader: K Column )
Call Data Sheet , I have the User Ids ( D Column) and the number of account IDs (F Column). Account Ids can be duplicated...

I don't see a file matching that description.