Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
does ctrl f select cells randomly?
I am doing statistical analysis and as part of explaining my research
methodology I have to clarify my sampling method. I selected my sample from a large spreadsheet by using the ctrl f tool to look for care homes within different geographical areas. the first home that came up for that area i selected and entered into my sample. My supervisor is asking whether this was random sampling ie how does ctrl f come up with its selection? alphabetically or the first one it comes across in that spreadsheet or by some other method? Can anyone help? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
does ctrl f select cells randomly?
tc,
I think it searches by rows by default, meaning it starts the search at the active cell, going across the row to the right, then the next row down, left to right, etc. This means it won't find a cell to the left or above the active cell until it's gotten to the bottom of the used range and looped around to the top. To change it to search by columns instead of rows, click the "Options" button in the Find dialog. If you've changed the option, it will apply the next time you start the search (Ctrl-f). If you do a lot of this, and want to avoid having to check and set all this stuff, you might want to record a macro that sets the active cell where you want to start the search, sets it to row or column, etc. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "tc" wrote in message ... I am doing statistical analysis and as part of explaining my research methodology I have to clarify my sampling method. I selected my sample from a large spreadsheet by using the ctrl f tool to look for care homes within different geographical areas. the first home that came up for that area i selected and entered into my sample. My supervisor is asking whether this was random sampling ie how does ctrl f come up with its selection? alphabetically or the first one it comes across in that spreadsheet or by some other method? Can anyone help? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
does ctrl f select cells randomly?
Depends on where you start looking. try with a blank ws and "a" in a few
cells. Now do it from different places to see what happens when you find "a" -- Don Guillett Microsoft MVP Excel SalesAid Software "tc" wrote in message ... I am doing statistical analysis and as part of explaining my research methodology I have to clarify my sampling method. I selected my sample from a large spreadsheet by using the ctrl f tool to look for care homes within different geographical areas. the first home that came up for that area i selected and entered into my sample. My supervisor is asking whether this was random sampling ie how does ctrl f come up with its selection? alphabetically or the first one it comes across in that spreadsheet or by some other method? Can anyone help? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
does ctrl f select cells randomly?
I just did a sample test, and typed a 2-character string into a large
spreadsheet to search for.....it starts from the top row and left-most cell and goes to the right and then down...like it's reading a book. It does not do it randomly. Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "tc" wrote: I am doing statistical analysis and as part of explaining my research methodology I have to clarify my sampling method. I selected my sample from a large spreadsheet by using the ctrl f tool to look for care homes within different geographical areas. the first home that came up for that area i selected and entered into my sample. My supervisor is asking whether this was random sampling ie how does ctrl f come up with its selection? alphabetically or the first one it comes across in that spreadsheet or by some other method? Can anyone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Randomly Select Records | Excel Worksheet Functions | |||
Ctrl Key to Select Cells | Excel Discussion (Misc queries) | |||
how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
randomly select numbers | Excel Discussion (Misc queries) | |||
randomly select value WITHOUT changing | Excel Worksheet Functions |