I have a data set of 1000 numbers and want to select the data from cells which are multiple of 5.In this way i want to select a sample of 200 samples.
For example I have data in A1 to A1000 cell then i want to select data from cells A5,A10,A15 and so on till A1000.
I don't want to use INDEX,VLOOKUP,SAMPLING functions and not even want to wirte any macto for this.
Is there any way to do this by using some formula.
I have a data set of 1000 numbers and want to select the data from cells which are multiple of 5.In this way i want to select a sample of 200 samples.
For example I have data in A1 to A1000 cell then i want to select data from cells A5,A10,A15 and so on till A1000.
I don't want to use INDEX,VLOOKUP,SAMPLING functions and not even want to wirte any macto for this.
Is there any way to do this by using some formula.
I will potentially have a list of data (Customers) the list could be 200+ lines long. Each customer belongs to a branch.
For eaxmple 10 customers branch a, 24 customer branch b etc etc.
I am going to be auditing the customers based upon a 30% sample.
So I want a random 30% sample of customers from branch a, sample branch b, sample of branch c etc. In order to then audit
What I want to do is have excel either highlight randomly 30% from branch a, branch b etc, or give me a new list? or some other way for me to pull the data out of the main list.
I have not got a clue how to do this? Any help anyone?
Thank you in advance
I've got a dilema. I am needing to return a random sample from 12 linked tables housed within a main db. Currently I am inserting a rand number in each record from each table, sorting each table, and then select X amount of records from each table and putting into a temp table to house the data. Is there a simpler way. This process is taking a very long time to run, approx. 8 min. per table.
Good evening
I have a large sheet of data, and I need to sample individual rows as part of random testing.
In column A is someones name, in column B a unique reference. In column C - is there a formula I can copy down which will display text/value that shows the row has been selected as part of a sample? For each user name in column A, I need to select TWO unique references from column B. As there are a number of different users in A, it is too tedious to do this manually. An example of the data is:
Column A Column B
Hi
I am getting frasturated with excel.
I am using Ebay UK not USA
Turbo Lister 2
Excel 2003
Does anyone have a sample or blank Excel spreadsheet that I can look at? I will try to use it to import data to Turbo Lister 2.
Either already converted to CSV or not.
I am trying to understand how the import system works. I have spent many hours trying to solve the problem.
I really appreciate any help.
Hello,
First and foremost, I am on Windows XP and using Excel 2003. I have some moderate level of understanding of basic Excel functions and formulae, but zero experience with VBA and macros.
All right, now that that's out of the way, let me start off by stating what I am trying to accomplish: I have a workbook with several sheets. Various users other than myself will be filling out drop-boxes that I have created on the sheets of the workbook. Based on the results of these users' input, I want to generate a list that pulls some data from the tables on the sheets these folks are working with and consolidate it on a separate sheet. I will not know how many rows will be needed, as this will change as the drop-boxes are altered. I also need this consolidated list to update while the other users are still working on their parts of the document.
Let's try to illustrate with an example:
-Sheet 1, 2 and 3 have the following (or similar) information:
Front
Side
Rear
Aston-M
Pass
Pass
Fail
Lotus
Fail
Pass
Pass
Tesla
Pass
Pass
Pass
Ferrari
Pass
Fail
Fail
Each of the Pass/Fail fields is a drop-down list that I have defined, but the actual results will be reported by other users.
On Sheet 4, I would like to generate a list that looks through Sheets 1, 2 and 3, finds all of the "Fail" results and then creates a list on Sheet 4 that lists the contents of Column A (the name of the car), then the title of the column in which the "Fail" was reported so that they can put any notes related to the failure on Sheet 4. Here's an example of what I'd like to see *magically* appear on Sheet 4 based on the results from the example above, where column A and B are created automatically and the user can then fill out column C:
Aston-M
Rear
Note: Test Dummy fatality on initial rear impact
Lotus
Front
Note: Test Dummy ejected from vehicle
Ferrari
Side
Note: Test Dummy decapitation
Ferrari
Rear
Note: Test Dummy spontaneous combustion upon impact
My hope is that this could create one consist list of all of the "Fail" conditions and allow room for additional notes to be taken.
I have been scouring Google looking for some guidance, but have yet to find any. I know that I could use VLOOKUP and HLOOKUP to grab the values that I'm looking for, but I believe with this approach, I would likely end up with a ton of blank cells or gaps in the list. I'm sure there has to be a better solution out there.
Any help would be greatly appreciated, and thanks in advance!
Dear all,
I was hoping someone could help me with this problem. I can bundle my way along with VBA in excel, but I am stuck when I try to use it across Office applications.
My wish is to do the following
1) in a slide show select a PCT from a drop-down menu
2) this will then query a spreadsheet (simple index function)
3) on preceeding slides it will show data specific to the chosen PCT (data and graphs)
If someone could point me in the right direction it would be much appreciated
Many thanks
Dave
