Hello Everyone,
My querie is the following:
I have three Columns of random numbers which will always range from 1 to 31. An additional row of random numbers (within the given range) will be added to these three columns routinely.
Is it possible for excel to do two things:
1) Give me a list of the most uncommon numbers in a single column.
2) Give me a list of any numbers between 1 and 31 that aren't present in that same column.
I hope my explanation is clear enough.
Cheers
Tom
Bookmarks