Frequency: Excel equivalent?

3344
3
03-18-2015 10:05 AM
AdamKuch
New Contributor

I have used the Frequency tool in ArcGIS, and have found it very useful for my info. But is there a similar tool in Microsoft Excel? I could import the data into GIS and run Frequency, but the Excel file I'm working with does not yet have location data. It will be easier to leave it in Excel for now.

Thanks!

Tags (3)
0 Kudos
3 Replies
ChrisDonohue__GISP
MVP Frequent Contributor

One of these Excel workflows may do the trick:

Count unique values among duplicates

Chris Donohue, GISP

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

You can accomplish what you want, and a whole lot more, using Pivot Tables.  Pivot Tables are quite powerful and the learning curve isn't too steep.

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

If you are using shapefiles, try FieldStatistics if provides several option frequency distribution types

0 Kudos