Value Counter - Please Help

  • Thread starter Thread starter Cip Loera Jr
  • Start date Start date
C

Cip Loera Jr

I need to count the number of occurances for data. I combine two fields to
somewhat give me a unique identifier. Cust Num and Amount. I want it to count
each value within that group

ie
These are the results I wishing to get

Unival Count
123456700.00 1
12341117800.90 1
12344445444.80 1
12344445444.80 2
2884444980.89 1
2884444980.89 2
2884444980.89 3
 
Thank you for your response,

I need each value to show the count, each instance of the value show what
the count is for it.

Value1 would show "1"
Value1 would show "2"
Value2 would show "1" since its the only one instance
Value3 would show "1"
Value3 would show "2"
Value3 would show "3"

My purpose is to get this to combine it with other fields that will somewhat
make it unique and would be able to compare to another source that has the
same info but may not have the same number of instances and will let me know
which those are.

Thanks again
 
Back
Top