Read Data and Create Report

[kvonatzigen]

Alrighty,

So I have a database of information that I compile weekly. This data is stored on a worksheet "DATA". I would like to read "DATA" and search for when a variable (account) is on there multiple times (2, 3, 4, etc..whatever I decide for my parameter to be).

Can anyone help please? Thank you very much!

 

[Excel Chimp]

Try the COUNTIF function. Select your range, then input the variable you want as the criteria, such as an account number.

 

[kvonatzigen]

Thanks Chimp, I appreciate the input! This is actually how I'm creating the report now. I have a list of accounts that I watch and compile information on a weekly basis. The problem is I have to know the accounts and manually input them into the countif function.

What I'm looking for is something that will scan the column of data and return to me the accounts that have been repeated multiple times without me having to manually tell it what accounts to look for. Something along the lines of countif but more countif - if it's been on there 2+ times. While returning each account that is on there 2+ times into it's own row.