Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates in Rand Formula
Hi,
Can anyone help me out. I am generating a random list from a larger list range. My problem is that I it cannot duplicate the first two characters in the list. For example: a portion of my list looks like: 55-GWP44934A 55-GWP45138A WD-CLP35803N WD-CLP97487G WD-CLP97700G WD-GWP19171D WD-GWP27830C WE-GWP27974C WE-GWP28039C WI-GWP45072A WI-GWP45080A WI-GWP45081A WI-GWP45166A WI-GWP45173A WJ-CLP93221H WJ-CLP97539G WJ-CLP97541G My formula that is generating a random selection is: =INDEX(MRO!$C$2:$C$49400,INT((RAND()*UW!$C$56)+1)) I am getting a return value but what I need is for it not to give me more than one based on the first two characters of the list. Does that make sense. For example: I cannot have it return me two values that both begin with WI. Can anyone help me out? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
Creating a formula using RAND | Excel Worksheet Functions | |||
array formula with duplicates | Excel Discussion (Misc queries) | |||
Formula to recognize Duplicates | Excel Worksheet Functions | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions |