Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate cells
need to identify duplicate cells when using the =rand function.
ive tried =countif =match if statements and nothing works. I was just wodering if there was a simple function to use, that can detect duplicates in a range of cells, and maybe also show you how many, for example in lottery. Also following that, is there a function that can stop duplicate numbers from appearing whilst using the =rand function? Thanks GTR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate cells
The best way is to use two columns when you are looking for random numbers.
If you want 1000 random numbers put 1 to 1000 in columnA. Then put in column B the formula =RAND(). Now sort the two columns using column B as the Key. column A will be a sorted list with no duplicates. "GTR Students" wrote: need to identify duplicate cells when using the =rand function. ive tried =countif =match if statements and nothing works. I was just wodering if there was a simple function to use, that can detect duplicates in a range of cells, and maybe also show you how many, for example in lottery. Also following that, is there a function that can stop duplicate numbers from appearing whilst using the =rand function? Thanks GTR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Cells | Excel Worksheet Functions | |||
Duplicate cells | Excel Discussion (Misc queries) | |||
Duplicate cells | Excel Discussion (Misc queries) | |||
Duplicate cells | Excel Discussion (Misc queries) | |||
Duplicate Cells | Excel Discussion (Misc queries) |