Does anyone know of an Excel formula that would count the unique values of the first 11 digits (all digits before the underscore)
IMAGE_ID
08676724002_1038260.eps
08676724006_1130460.eps
08676724006_1453134.eps
08676750004_1405277.eps
08676750006_1101494.eps
08676750006_1453135.eps
08676751006_1353510.eps
08676751302_1096034.eps
08676751302_1117999.eps
08676751302_1318708.eps
08676751302_1336658.eps
08676751302_1353509.eps
08676751306_1094061.eps
08676752004_1405278.eps
08676752006_1082618.eps
08676752006_1453136.eps
and summarize them as such:
IMAGE_ID COUNT
08676724002_1038260.eps 1
08676724006_1130460.eps 2
08676750004_1405277.eps 1
08676750006_1101494.eps 2
08676751006_1353510.eps 1
08676751302_1096034.eps 5
08676751306_1094061.eps 1
08676752004_1405278.eps 1
08676752006_1082618.eps 2
Bookmarks