Selecting random cells based on criteria

mesTrethowan · #1 10-27-2015, 05:16 AM

the formula appears to list the records sequentially as they appear in the data set.

So if I want 25 results for letter "T" it list the first 25 records it finds, anything after this is hidden.

Therefore if I have a total of say 150 records that are coded "T" number 1 - 150 the formula seems to list values 1 - 25 while hiding 26 - 150 thus not random.

Hope that makes more sense.

xor · #2 10-27-2015, 05:57 AM

I am still in doubt, but maybe:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Matching Criteria against a range when criteria is not in contiguous cells??	GMorris	Excel	9	08-20-2014 02:15 AM
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
Selecting merge field based on whether or not text is present	amym	Mail Merge	1	12-07-2010 05:14 AM