Hello everyone,

After 4 days of unsuccessful searching (forum, excel, etc) i need your help !

I have a range of numerical values, lets say A1:E10 (the list is much bigger).

I need to find how many duplicates (done this with the coutif function), locate them in the table (done this with conditionnal formatting and the countif function), but what i do ideally try to achieve is to get a table listing all occurences of the duplicates :
for example
Value 120 in cell A3 is duplicated 2 times, and is also found in cells B4 and E7
Value 120 in cell B4 is duplicated 2 times, and is also found in cells A3 and E7
Value 120 in cell E7 is duplicated 2 times, and is also found in cells A3 and B4

This would do too :
Value 120 is found 3 times, in cells A3, B4 and E7

Can anyone help me with this ? We would gain much time (the conditionnal formatting and the countif function are doing a great job, but amongst all duplicates i still have to manually search the matching ones and the list is long).

Thanks in advance
Kris