I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. The result of each crossed two rows must count the common numbers and only if the count in the duplicate numbers is 5 or 6 the those duplicate 5 or 6 numbers must be output on a new sheet. If the number of results is more than 500000 the results must continue to cells away from the first row result.
27 freelancers are bidding on average $44 for this job
Hi there. I am Excel VBA expert . I can do this project utilising my VBA skills and my experience in handling such jobs. Looking forward to working with you.