Hi guys,
Need help... So, I receive files everyday with random data. My job is to find out duplicated numbers in the file.
let's say... if number 10 appears 5 times in the column A B C D E I should detect it.
The main issue is that I don't have the list of numbers which I must find and I don't know how many number I must find.
I just receive file every day with 5 columns. each column might contain up to 1000 records and I should find duplicated numbers which repeats in these 5 columns.
I should define numbers which are displayed more than 4 times in these 5 columns in total
Example is in attached file
Bookmarks