I have several excel tables with a large amount of data that I have narrowed down to FIPS_CODE and the ag production data in order to join them to a county level shapefile. The tables have duplicate values for each county, when I join the duplicates are no longer there. My question is, when ArcMAP decides to eliminate duplicates, such as in this case, how does it do it? - Median? (which would be ideal since this is what I needed to do anyway) - Average? - First occurrence? Any help would be great, thanks.
... View more