1. Search only within rows. Search for exactly 8 (random) values in the entire range of rows, that repeat in at least 2 rows or more.
1. Search only within rows. Search for exactly 8 (random) values in the entire range of rows, that repeat in at least 2 rows or more.
Last edited by Ad8r; 12-15-2021 at 04:12 AM. Reason: I am soo sorry, I was in a hurry
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Your sample shows consecutive "paired" rows but (I suspect) this is NOT the real case: there could be more than pairs of repeats spread through many rows - and only 4 numbers per row ?????
If the above is correct, post a more representative set of data
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Your duplicate thread has been closed. Continue here, please.
I cannot see in the attachment where you have mocked up what you want.
I said this:
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Please add some expected results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks