Excel to return a value of one on the first instance of finding a duolicate field in a tabled column
Posted on 2013-01-16
hard to phrase, but here goes;
a) have a column of data that occasionally has duplicate values. Have an adjacent column with =IF(MAX(COUNTIF(F:F,F:F))>1,"Yes","No"
b) next colmun over returns a 0 if No and a 1 if Yes
c) issue is, i only want to the number of instances of teh duplicates, not the total number of duplicates (the total number of "Yes"
This is a bizarre report based on Access Tables with Pivot Report outputs to achieve a syummarized report. there is a long winding road why this is; but it is and that means the tally of unique records can;t depend on sorting, conditional formatting or juts a tradition Excel type solution. really should be an Access query, but another long story is "not possible" must be a read only data connection from Access tables to Excel.
I can try anything; just has to return the duplicate value count only once in a numeric way that can be summed at the row level. Again, hard as heck to even phrase teh question. Any takers, please?