Posted to microsoft.public.excel.misc

Posts: n/a

Random Sampling rows

Hi

I have an excel sheet with data in range A1:G1000. I need a random
sampling function to just highlight say about 5% of the rows in a
different colour, or show them on a different cell range in the same
sheet.

i tried using RAND() but it doesnt seem like what I am looking for.

Cheers
Sunny

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
Rows & Columns in Excel	seadragon69	Excel Worksheet Functions	2	December 7th 05 05:54 PM
Random Sampling	Andrea	Excel Discussion (Misc queries)	2	November 11th 05 09:52 AM
Automatically inserting rows	ausdiver99	Excel Worksheet Functions	1	June 2nd 05 02:15 PM
Hiding Rows if the linked rows are blank	KG	Excel Discussion (Misc queries)	9	May 18th 05 02:32 AM
flexible paste rows function that inserts the right number of rows	marika1981	Excel Discussion (Misc queries)	1	February 18th 05 02:40 AM

All times are GMT +1. The time now is 02:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us