Freq distribution problem

Hi Excel Forum,
I have a big Excel 2010 data set (a small fictious portion attached).

Question:

I need to find out how many different FSAs are there in this dataset.

I know in SAS we can use proc freq but in Excel how could we find it?

Thank you for the help.

Mirisage

Hi Mirisage,

Are all the FSA codes in column B or separated over multiple columns?

Hi English_Bloke82,

Actually they are separated over multiple columns.

Thanks

Mirisage

Sorry for my ignorance, but I'm not even sure what an FSA code is. Some type of a postal code, in Canada I think, but I'm probably mistaken.

Assuming an FSA code is always three digits in length, and assuming the middle digit is always numeric and the first and third digits are alphanumeric, (as your sample worksheet seems to indicate) then this macro will tell you how many different FSA codes are in your worksheet.

Change the max number of rows and the max number of columns as needed.

It seems to work for all of the test data I gave it. Your small worksheet, for example, contained five different FSA codes. (B7U is written twice.)

If I'm completely wrong about what an FSA code is, my apologies. But maybe you can still use and modify the macro to fit your needs.

Please Login or Register  to view this content.

Hi Ed_Collins,

Thank you very much for taking time to write this macro.

I should take time and try to learn the logic behind this macro.

Thanks again!

Mirisage