Collecting Cell Values
Dec 15, 2009
I have several sheets which give me results, e.g. "dummy1", "dummy3" and "dummy5" out of a list of all possible dummies 1 to 10. It is possible that there are any number of "dummy5" (or any other dummy) outcomes.
I just want Excel to make a list of all the possible outcomes.
In this case, I want Excel to make a List that says:
"dummy1"
"dummy3"
"dummy5"
This means Excel shall search the respective Columns and just check, is this dummy there or is it not.
View 12 Replies
ADVERTISEMENT
Dec 20, 2012
I gather two lists of serial numbers (i.e.) from two different sources; one populated in sheet1, A:A (with variable row numbers) and the other in sheet2 B:B (again with varying number of rows)
I am trying to gather a master list of unique serial numbers in sheet3, C:C.
So far I have tried advanced filter, union.range, etc. but couldn't figure work it. I guess some of these columns need to have names assigned to it and have a header.
View 9 Replies
View Related
Mar 16, 2014
As per attached sheet, I have the date distributed in two three cell and want to transfer data to single cell. I don't know which formula has to use to collect it together.
need solution.xlsx‎
View 2 Replies
View Related
Jun 22, 2007
What I am looking to do is pull all the data of clients with assets under $2million into another tab. How can I do this without copying and pasting? I am looking for either a macro or some kind of formula that will search the entire data dump and pull in just the clients I need without leaving any rows blank.
View 9 Replies
View Related
Aug 27, 2009
It is a small program for learning new words of a foreign language.
By means of a userform one can add new words to the program which will be stored on a sheet called "data" each new data entry will get a subsequent number.
On the main-sheet "werkblad" one can by giving 2 numbers from between which to collect the data retrieve the words they want to learn.
For example. If on the mainsheet in cell B3 the number 3 will be entered and in cell C3 the number 12, only those words will be shown with a number between 3 and 12.
However sometimes I would like these words to show up in randomized order. So I made a new collumn on the "data" sheet with the following formula =rand() and sorted it, but unfortunately the formulas on the "werkblad"-sheet don't present the given numbers [3 till 12] in randomized order.
The formula I use for collecting the data from the "data"-sheet is the following:
View 8 Replies
View Related
Dec 17, 2009
I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number
The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other
Are there any functions that will allow me to do this?
View 6 Replies
View Related
May 11, 2011
I need a code to select sheets with pages less than 15 to print out. Also, a code to print out just the first 5 and last 5 pages if its more than 15 pages.
I've tried this so far but no success:
For X = 1 To Worksheets.Count
If Y Is Nothing Then
Set Y = Sheets(X)
Else
If ExecuteExcel4Macro("Get.Document(50)") < 10 Then
Set Y = Union(Y, Sheets(X))
End If
End If
Next X
Y.Select
View 6 Replies
View Related
Jan 10, 2008
i have wordlists which i would like to enhance through texts. For that purpose i need a macro which reads a text and splitts it into words and put the words into three columns. Lets assume the column where the words are supposed to be put is columns A,C and E. The column A should contain single words containing no spaces from Text, column C should contain compound words which have one space between them and in column E those compounds which have two spaces. Now i will put my existing wordlist in column G before i start splitting texts. The macro should put only those words from text into column A,C and E which dont already exist in columns A,B,C,D,E,F and G. In Column B i will place the corrected or checked words from column A. In column D i will type the corrections and checked versions of those compunds existing in column C. And the column F will contain the compound words which are corrected and checked from Column E.
Column A--> single words splitted from text through macro (containing no spaces)
Column B--> corrected and checked versions of words from column A through user
Column C--> compound words containing one space splitted from text through macro (for example:"etwas möchten" or "do something")
Column D-->corrected version of C through user
Column E-->compound words containing two space splitted from text through macro (for example:"sich uerberzeugen lassen" or "down in dumps")
Column F-->corrected E
Column G--> existing dictionary wordlist through user
Signes like ".", ":",";", "/" or quotation signe itself should be seen as seperator. And the words or compounds splitted from the text should not contain these signs.
The text will be put in another sheet in the same excel file. Lets call that sheet "text". The macro should search for words through whole sheet ignoring empty cells or columns.
None of the columns should be filtered or ordered. The columns shound not be deleted as well. That way the user wont have to correct the same word each time cus the corrected as well as the original words will be there.
A thread with similar purpose was made sent by AdamDay as well, where rylo has posted a good solution already.
View 14 Replies
View Related
Dec 10, 2013
I would like to create a menu representing "tasks" where an amount of "time" can be designated per option for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
So far, I've created a table where a "time" input is nested beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.
For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".
Here's the file, what I'm trying to accomplish [URL] ............
View 1 Replies
View Related
Mar 31, 2014
I have one column of data. there are currently ~10k rows, but this will increase over time. each row has either a single value (example: pepsi) or a comma separated value (google,samsung) with up to 6 commas. instead of the rows looking like this:
pepsi
google,samsung
coca-cola
I want them to look like this in one column (preferably via a formula):
pepsi
google
samsung
coca-cola
I would like the above output to be a unique, alphabetized list.
View 8 Replies
View Related
Jun 27, 2014
write a script to match a cell value then copy and paste the matching row across two worksheets - "Master List" and "Demographics".
These two worksheets have the same cell values in Column A, the key difference is the Column A cell order in the second worksheet "Demographics". This Column A cell order is set arbitrarily by another system and will vary over time.
I would like to match the rows, then paste the three columns from the second worksheet into the first worksheet.
For example:
"Demographics" Worksheet Cell A2 = "Master List" Worksheet A45 - then copy cells A2, B2 and C2 and paste into A45, B45, C45 respectively.
"Demographics" Worksheet Cell A49 = "Master List" Worksheet A12 - then copy cells A49, B49 and C49 and paste into A12, B12, C12 respectively.
I have created a sample spreadsheet here; - List Schema.xlsx
View 2 Replies
View Related
Jun 5, 2014
I request you to write a code for me to fill the cell values as "Not Applicable" in Column "AZ", if the "B" Column cell values = "Justified", "Approved LSAR" & "Approved SDAR".
I have attached the work book of what I am trying to accomplish.
View 14 Replies
View Related
Oct 27, 2009
Here's an example of what i'm working with,...
Range is C40:D48
View 4 Replies
View Related
Mar 2, 2012
it should compare and see if product, model for same id is the same but brand is different and the quantity of one or more of those brands=0 then the result (In column F)should combine the brands. check the attached image for more details.
View 5 Replies
View Related
Jun 6, 2014
Cells B3 and B6 both have lists created through data validation.
If the value in B3 changes (by user selecting from the list), I'd like B6 to automatically change to "Select a take to retrieve" (which is the first choice in the B6 list.)
Likewise, if the value in B6 changes (by user selecting from the list), I'd like B3 to automatically change to "Select a version to take" (which is the first choice in the B3 list.)
View 1 Replies
View Related
May 22, 2014
What I have In Column B, I have the datesIn Column I, I have engineers name What I need I want a macro to generate Serial Nos. (1,2,3....... n) in column A If an only if the date in column B is today's date and the engineer's name matches with the PC's username
The following is my code
[Code] ....
Above code runs without errors but does nothing.
View 4 Replies
View Related
Jul 2, 2009
I have data similar as shown in the following:
A1A11
B2AA1122
C3B22
D4C33
D44
The idea is to add compare the cells of the first column with the third column. Where same letters/words exist, the corresponding value of the first column should be added to the second column (where no letter exists equally, the space remains empty), so it will look like this
A111
AA1122
B222
C333
D444
the third column always will have at least the same letters as the first column, but new letters/entries can occur.
View 3 Replies
View Related
Jun 5, 2012
I have .csv file from which the data is importing to master schedule. i have a column in .csv file which is spitted into multiple columns. and my need is i have to compare this each individual cell value with the range of header values in master schedule and if match found i have to place that cell in the row.
I am adding 2 attachments one is .csv and other is master schedule.
I couldn't able to find where i have to attach my files.
View 2 Replies
View Related
Aug 31, 2012
I want to build a database where the user can select a specific time period. I have a static file with the time periods and the related values. For instance I have in column A1:A15 the time periods from January 2011 to Dezember 2011, but I have some dates multiple times as there are more values attached to it. For instance I have in the first 4 rows January 2011...what I want is when someone puts in the value January 2011 in cell B1 and Dezember 2011 in cell B2 that the whole static file gets copied to another location (including the multiple dates) displaying the chosen time period. Similarly if someone puts in the value March 2011 to November 2011, I want only those values to be copied.
View 4 Replies
View Related
Jul 23, 2014
two formulas for one data set. The data is attached in the spreadsheet: "Product IDs". The data is a set of Master Product IDs (parent) and the Linked to them Products (children). I need to create a relationship between unique parents (Master Product IDs) and their children (Linked Products)
I need to create two formulas:
1. From the Data Set table, need to vlookup the unique value in column A (Master Product ID) and return comma delimited (concatenated) corresponding values from column B (Linked Products). So, the result will be as shown in Table 2.
2. From the Data Set table, need to vlookup the unique (de-duplicated) parent/children relationship in column A (Master Product ID) and return comma delimited (concatenated) corresponding values from column B (Linked Products). There are total 3 parent/children relationships in Table 1. So, the result will be as shown in Table 3.
View 8 Replies
View Related
Jul 19, 2012
Column C5:C9999 & D5:D9999 contains alphanumerical values.
In E5:E9999 i want the result=Column C provided it matches Column D else null.
Ex:
C5=Peter ShowROOM D5=RooM E5=Peter ShowROOM
C6=Peter ShowROOM D6=r sh E6=Peter ShowROOM
C7=PeterShowROOM D7=r sh E7="" (null)
C8=PeterShowROOM D8=P E8=Peter ShowROOM
View 5 Replies
View Related
Jan 7, 2009
If I have, in one cell (call it D1):
EH,DR,HU
and in a lookup table on another sheet:
A B
1 ED T
2 EH F
3 DR G
4 HU H
5 SE E
6 YU E
I need to be able to lookup the values in D1 on the table and return the values in column B to a single cell (say E1), also comma separated...
eg...
F,G,H
View 9 Replies
View Related
Jul 7, 2013
I'm attempting to assign 1 of 4 predetermined values to a cell based on the values of entries in another cell.
View the example attached : Value assignmts.xls
Assign the Value of 1, to (D8) when any value entered in (C9) is equal to or over 380, but less than 410.
Assign the Value of 2, to (D8) when any value entered in (C9) is equal to or over 410, but less than 440.
Assign the Value of 3, to (D8) when any value entered in (C9) is equal to or over 440, but less than 470.
Assign the Value of 0, to (D8) when any value entered in (C9) less than 380.
View 9 Replies
View Related
Dec 19, 2013
I have a table of times which shows how long it took someone to process a form. If this value is longer than 10 minutes the cell next to the duration time contains the value 'Break Over Ten'. This is only true when the time is outside of 12:00 to 14:00. If the break is within this time period it shows 'Lunch'.
Is it possible to sum all of the time values that are over flagged as 'Break Over Ten'? This is how it looks
Event Date Start Time End Time Duration Breaks Duration Of Break
19/12/201308:43 08:43 00:00:35 00:00
19/12/201308:43 08:44 00:01:03 00:01
19/12/201309:05 09:19 00:13:15 BREAK OVER TEN00:13
19/12/201309:05 09:19 00:13:15 BREAK OVER TEN00:13
I was thinking of using SUMIF but can't work out how to total the values in the duration of break column when the cell to the left reads break over ten. Is it possible to do this?
View 1 Replies
View Related
Apr 21, 2014
I have done this before, but it has been a while since Ihave had to use VBA code. What I want to do is find and replace every occurrenceof a test string within a formula with a text string in the first column ofthat row. In the example (I have omitted the formula and left just the word toreplace). I used to have a simple VBAMacro, but not sure what I did with it!
Bob David David David --Every Davidreplace with BOB
Tom David David David --Every Davidreplace with TOM
Fred David David David --Every Davidreplace with FRED
Matt David David David --Every Davidreplace with Matt
View 5 Replies
View Related
May 2, 2012
So I have sheet with various values.
I have a rather big XML type column where I want to replace values (in green) with thier corresponding cell values. Im pretty sure this can be done but have tried with no success!
item>TEST POST http://domain.com/Good StuffCan Be ListedLike ThisOkay StuffCan Be ListedLike This
Bad StuffCan Be ListedLike This]]> 102011-07-07 19:41:16 2011-07-07 19:41:16openopengrand-canyonpublish 00post0
_edit_lastkeya:6:{s:4:"zoom";s:2:"14";s:8:"latitude";s:8:"36.34313";s:9:"longitude";s:10:"-112.51339";s:11:"address_one";s:12:"Grand Canyon";s:11:"address_two";s:12:"Williams, AZ";s:6:"bg_img";s:0:"";}]]>_thumbnail_id
View 3 Replies
View Related
Sep 1, 2007
I am trying to write code that runs a calculation on each cell in a range and replaces the current value with the calculated one. The calculation is very straightforward (see green range in example file)- instead of the absolute value in a cell (yellow range) it displays the ratio of said cell value to a value from another column (blue range). Basically, after running the macro, the green cells (just formatted for ease of reference) would replace the yellow ones.
View 5 Replies
View Related
Jun 28, 2009
I have a little bit of problem with lookup function. When i paste values from another worksheet (paste special, values) in a cell which is lookup value i get #N/A. These values are numbers. When i put '7 for example i get the values i want from lookup table. I have a lot of these cells and its tedious job to put ' in front of every value. Is there a quicker solution?
View 3 Replies
View Related
May 31, 2014
See the attached excel table. I need the cell E4 to keep adding the values typed in the cell D4 on daily basis.The cumulative shouldn't be changed if there is no value in the cell D4. E4 should accumulate and keep the totals typed in D4...
Cumulative Input.xlsx‎
View 5 Replies
View Related
Mar 25, 2013
Below is my code which isn't formatting the cells it's suppossed to. It looks like it isn't doing anything. I think the issue might be with the highlighted section of my code, but when I go to "Manage" my rules for conditional formatting, excel references the appropriate cell under the "Applies to" section. I am using relative cell references for for the majority of the rest of the code and this section follows a section that selects the correct cell for this conditional format.
Code:
Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=""ABS()>.005"""
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority[code].....
View 1 Replies
View Related
