Select to view content in your preferred language

Frequency: Excel equivalent?

3746
3
03-18-2015 10:05 AM
AdamKuch
Deactivated User

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 Alum

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 Emeritus

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

0 Kudos