Extract Repeat Values

[kamcreationz]

Hey guys,


I am helping a friend with a statistical model and he wanted to know the repeat values. Till now having conditional formatting was enough (highlight the repeat values with simple countif[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]=COUNTIF($H7:$M7,B7)>0[/TD]
[/TR]
</tbody>[/TABLE]
was serving the purpose but now he wants to do further processing on the repeat numbers)



can some sort of array formula be used? or even better a custom function where the function takes the two ranges and returns the repeat values.

There is much info on internet on removing the repeat/duplicate values but not didnt had much luck in finding vba code to extract/ list duplicate values

Here is a sample of what i have done till now and what i am trying to achieve ( there are around 10 tables like this and each one has around 10 -15 rows)

https://www.dropbox.com/s/9dn3sm3rwdwwm6u/Repeat Values.xlsx

Any help or even a nudge in the right direction would be highly appreciated



Thanks