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, 03:59 AM

mesTrethowan mesTrethowan is offline

Windows 10 Selecting random cells based on criteria

Office 2013

Novice

Join Date: Oct 2015

Posts: 7

Nearly there

Hi Xor,

thanks for the suggestion.

It is close but doesn't give me random results as it hides anything above the required value by changing the text format to white. so it seems to provides me with a sequential list of values.

« 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 08:02 AM.