Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

Random Text selection Q

I have 10 text statements in A1:A10. Is it possible to return in A15 1
radom selection from this range, only proviso is that if Z1=0, <blank
i.e. don't show anything in A15

Is this possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Random Selection	Craig	Excel Worksheet Functions	3	September 27th 07 05:18 PM
Random selection of text cells	CJ	Excel Discussion (Misc queries)	3	September 10th 06 07:05 AM
Random number selection	kwidener	Excel Worksheet Functions	5	September 5th 06 04:04 PM
Random Selection	Cookie	New Users to Excel	2	May 3rd 06 12:05 AM
Random Selection	Cris	Excel Worksheet Functions	2	October 16th 05 06:15 PM

All times are GMT +1. The time now is 08:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us