I have a table with many instances of duplicate values.
My end goal is to have three columns:
"The Value": a file name. most are non-unique
"Duplicate Instance": "this is the 1st time this file name appears in the list", the 2nd, the 3rd, etc.
"Total count of Duplicates": "this file name appears 5 times in this list"
I have the Duplicate Instance from @FelixP's answer to Auto incrementing field based on groups within feature class?
I can create a separate frequency table with the Frequency tool then join that table to calculate in the total count of each file name, but I would love to skip a few steps and directly calculate the frequency in the Field Calculator interface.
Is it possible to directly calculate frequency in ArcGIS Desktop Field Calculator?