topic Re: Frequency: Excel equivalent? in Data Management Questions https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64823#M3746 <HTML><HEAD></HEAD><BODY><P>If you are using shapefiles, try <A href="http://www.arcgis.com/home/item.html?id=6c384f06c9f14d09920f4ff14460f4e2">FieldStatistics</A> if provides several option frequency distribution types</P></BODY></HTML> Wed, 18 Mar 2015 19:19:53 GMT DanPatterson_Retired 2015-03-18T19:19:53Z Frequency: Excel equivalent? https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64820#M3743 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Thanks!</P></BODY></HTML> Wed, 18 Mar 2015 17:05:10 GMT https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64820#M3743 AdamKuch 2015-03-18T17:05:10Z Re: Frequency: Excel equivalent? https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64821#M3744 <HTML><HEAD></HEAD><BODY><P>One of these Excel workflows may do the trick:</P><P></P><P><A href="https://support.office.com/en-US/article/count-unique-values-among-duplicates-8d9a69b3-b867-490e-82e0-a929fbc1e273" title="https://support.office.com/en-US/article/count-unique-values-among-duplicates-8d9a69b3-b867-490e-82e0-a929fbc1e273">Count unique values among duplicates</A> </P><P></P><P></P><P>Chris Donohue, GISP</P></BODY></HTML> Wed, 18 Mar 2015 17:13:32 GMT https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64821#M3744 ChrisDonohue__GISP 2015-03-18T17:13:32Z Re: Frequency: Excel equivalent? https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64822#M3745 <HTML><HEAD></HEAD><BODY><P>You can accomplish what you want, and a whole lot more, using Pivot Tables.&nbsp; Pivot Tables are quite powerful and the learning curve isn't too steep.</P></BODY></HTML> Wed, 18 Mar 2015 19:05:17 GMT https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64822#M3745 JoshuaBixby 2015-03-18T19:05:17Z Re: Frequency: Excel equivalent? https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64823#M3746 <HTML><HEAD></HEAD><BODY><P>If you are using shapefiles, try <A href="http://www.arcgis.com/home/item.html?id=6c384f06c9f14d09920f4ff14460f4e2">FieldStatistics</A> if provides several option frequency distribution types</P></BODY></HTML> Wed, 18 Mar 2015 19:19:53 GMT https://community.esri.com/t5/data-management-questions/frequency-excel-equivalent/m-p/64823#M3746 DanPatterson_Retired 2015-03-18T19:19:53Z