Selecting random cells based on criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Selecting random cells based on criteria

FAQ

Thread Tools

Display Modes

10-27-2015, 05:16 AM

mesTrethowan mesTrethowan is offline

Windows 10 Selecting random cells based on criteria

Office 2013

Novice

Join Date: Oct 2015

Posts: 7

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:00 AM.