If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Help

[Deleted User] · 2010-08-12 16:54:14

Hi guys, need a bit of help here. I've a large data set which has companies sorted by nace codes. Is there a way to easily see the amount of companies per nace?

12-08-2010 5:54pm

#1

[Deleted User]
Posts: 5,589 ✭✭✭

Join Date: -

Posts: 5589

Hi guys, need a bit of help here.

I've a large data set which has companies sorted by nace codes. Is there a way to easily see the amount of companies per nace?

0

Comments

#2 12-08-2010 6:22pm

[Deleted User]
Posts: 0 ✭

Join Date: -

Posts: 0

Pivot Table?

0
#3 12-08-2010 6:25pm

Économiste Monétaire

Closed Accounts Posts: 2,208 ✭✭✭

Join Date: March 2008

Posts: 2015

How exactly are the NACE codes formatted? The 'CountIf()' command might do the trick.

0
#4 12-08-2010 7:09pm

[Deleted User]
Posts: 5,589 ✭✭✭

Join Date: -

Posts: 5589

sorted it.
Created a row of nace codes, then pasted in the column from the data set.
Used =if col = row to creates ones for matches and summed them.

0
#5 12-08-2010 7:09pm

Time Magazine

Registered Users, Registered Users 2 Posts: 8,452 ✭✭✭

Join Date: February 2004

Posts: 7994

Export to Stata.

0