1.jpg
I have a row with four number A1 is 1, B1 is 26, C1 is 102 and D1 is 26. How can I find out the duplicate number 26 and show it in a new cell? Also I want to find out the cell which is greater then 100 and combine with the duplicate number shown as 26,102 in F1.
Bookmarks