Link to home
Start Free TrialLog in
Avatar of Sean Meyer
Sean MeyerFlag for United States of America

asked on

Excel 2010 - How to summarize a column of data over 3 sheets (150,000 + entries)

I have a column of data with number values which extends over three sheets of data (150,000+ entries).  I want to summarize the occurances of data.

IE What data is present and how many times it is present.

I tried to use a previous answer from Matthewspatrick https://www.experts-exchange.com/questions/27271531/Excel-counting.html

But I even need a basic tutorial on where to enter the equation into Excel 2010

Thank you
SOLUTION
Avatar of tdlewis
tdlewis
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sean Meyer

ASKER

You saved me MASSIVE amounts of time. Thank you.
Glad to help :)