Hello,
I have a Attribute table that has three columns In one column It states the name of well or its number next column it states the status of a program Active or Inactive and In another column I have Names of fields. My question is how do you relate the two columns or i should say analyze them. I need to count how many Active and Inactive are in each field. I figured out how to do it long way but I was wondering if anyone knows a short cut maybe somehow use one of the toolbox. below is a visual example of what i need to do.
Thank you.
Well name -------Field---------Well_Status
.77676---------------A ------------Active
.5---------------------A ------------Inactive
.6 ---------------------A ---------------Active
I need a total amount of active and inactive (Is there a way to do this I have huge amount of data like this to analyze)
Field------------------------Active--------------Inactive
A------------------------------2----------------------1
