Pulling Specific Data From One Column
Apr 16, 2009
Start Date: 1/1/08
End Date: 1/1/08
Users: 100
Description: ...whatever
What I want to do is pull just the end dates into the next column. Is there an easy way to do this or do I need to build a macro?
View 6 Replies
ADVERTISEMENT
May 23, 2013
I have a huge listed of assets - the column i where my info is has vasrious serial numbers.... some are a simple string of letters/numbers and the others look like this for example AG-1234567
I need to somehow pull out the ones that look like that. (AG-1234567). I only need those. Now normally i would just do a filter and pull em out however, this sheet contains 73k worth of items.
what would be the formula to perform such a task?
View 2 Replies
View Related
May 21, 2014
I have this spreadsheet where in there's a Raw Data. Along with is there's a different tab for different user, is there a way that if a certain user choose a date it will pull up the data for that date in the Raw Data.
What formula should I use? and how should I do it.
View 7 Replies
View Related
Jan 15, 2010
I have random comments in a column of cells of which I'm searching for a specific string of characters that may be contained in each cell. I want to pull 2 pieces of data from this specific string and place the data in 2 other cells in the same row.
Sample comments in cell 'N1':
..... blah, Appt: Friday; 12/4; night drop off. blah, blah....
Sample comments in cell 'N2' (and so on and so on):
.....blah, blah, Appt: Thurs; 12/3; 12:30PM. blah, ....
The specific string in the above examples will always begin with:
APPT:
Then the key elements found directly after the 'APPT:' are:
Thurs; 12/3; 12:30PM.
(which are the)
DAY; DATE; TIME.
These elements will be always separated by the semi-colon ';' and the string will always end with the period '.'
I need a pair of formulas to be in col 'J' & 'K' to extract the DATE and place it in column 'J' and the TIME and place in column 'K', both in each same rows.
So, from the 2 above samples I would need the following:
in Cells:
J1 - 12/4 ....... K1 - night drop off
J2 - 12/3 ....... K2 - 12:30PM
I've been trying to come up with a formula using a combination of FIND() & MID(),
View 9 Replies
View Related
Dec 17, 2013
I've attached a workbook with a description of what I'm trying to do. I'm not sure if it can be done with formulas or if it will require VBA. I can move it to the VBA section if the latter terms out to be the case. it's not that I'm opposed to copying code, I just like to know how it works with enough depth that I can fix/modify it, and I can't do that with VBA).
View 6 Replies
View Related
Oct 4, 2013
How to pull data based on column B to individual tabs.
I have the following data:
A B C D
Jane Doe | L1 | 20% | High
John Doe | L2 | 15% | Medium
Mike Smith | L1 | 60% | Low
Marie Smith | L4 | 10% | Low
I want to have the first tab/spreadsheet only pull records that have L1 values for column B
In the next tab/spreadsheet I want to pull records that have L2 values in column B etc.
What formula can I write that will pull all L1 records (A.B.C.D) in to Tab 1, then all L2 records (A,B,C,D) into the next tab?
View 10 Replies
View Related
Jun 14, 2013
I'm trying to find a way to use a macro to extract data from a specific column from Sheet1 based on the columns header/title and copied into Sheet2 into the respective column with matching header/title.
For instance, in Sheet1:
Chicken
Cow
Donkey
Pig
[Code]....
So the above table would be the result i'm aiming for.
NOTE, its not different workbooks. I'm looking for sheet to sheet macro.
I've attached a file as well if someone wants to have a go at it. There are no codes in it.
View 3 Replies
View Related
Jun 24, 2009
I was wondering how to input data on one sheet, then have specifics from that first sheet get sorted and put on the second and third sheet according to it's value. I have attached an example with my comments in red.
View 3 Replies
View Related
Jun 29, 2008
I have a workbook for a category of academic journals. It contains the journal name in the first column, the year it was published in the second and various bibliometric stats in the next twelve as follows: ....
View 9 Replies
View Related
Apr 22, 2009
What I'd like to do is; If column C contains data then insert a blank column and shift column C to the right.
View 4 Replies
View Related
Dec 11, 2008
I have a couple of columns that look like this in basic form:
Column A Column B
A 1
B 1
C 0
D 2
E 1
F 0
G 2
What I want is in a separate worksheet for it to pull the names (A, B, E) that have 1s next to them in column B and put them in a list.
I could do this kinda manually, but how can I create a nice list in a separate column on a separate worksheet just of the names (column A values) where there is a 1 in column B? All I can think to do is vlookup the data and put blanks where its not equal to 1 and then manually delete out the other rows.
View 6 Replies
View Related
Jul 8, 2014
I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
View 9 Replies
View Related
Sep 13, 2007
I need a formula which would take the last number that appears in a column and place it in A1.
The column is D10 through to D44 and the last number can appear in any one of those cells.
View 13 Replies
View Related
Nov 23, 2009
In this example, i need to get rid of all the rows except for the mfg part #. The heading "mfg part #" can be deleted as well.
The number of rows will vary each time i capture data. So for this example, i need 50 rows of data, but the next time i capture it, i might need to only keep 10 rows of data. The format will remain the same, the only thing that changes are the number of rows and the actual part #'s.
View 11 Replies
View Related
Jun 17, 2006
ive been writing a database for my business using excell and VBA
I have worksheets for clients surpliers labour and parts i have written userforms that add parts clients and surpliers to their respective sheets
I have started to white a userform that ties all this information together to create invoices it creates a new invoice number allows me to select which client the invoice is for and add labour to the invoice.
I have a txtbox called "txtsearchparts" and a button called "cmdSearchparts"
at this stage i can type a serialnumber into the "txtsearchparts" box and click the "cmdSearchparts" button. This saves the text that was entered into "txtsearchparts" as a variable called "partsearch".
I am having trouble with the last bit. once the serial number has been entered , the button has been clicked and the serial number has been saved in "partsearch" variable, i want it to search the first column of the "parts" worksheet the the serial number contained in the variable and return the row address that the part stored on to a variable called partaddress.
View 8 Replies
View Related
Aug 2, 2014
I am trying to pull titles out of a text string but its quite difficult because of how the data was originally inputted. I need titles that appear in the following different formats
" title"
title/
title"
These titles were not inputted consistently and it could show up in the middle or at the beginning. I have attached a sample of the data that i am working with and a sample formula that i was trying to use to obtain my information. The formula that i have is a nested formula of find and mid formula that searches for the text within " ".
View 5 Replies
View Related
Nov 12, 2007
HOW TO pull the unique values out of a column of entries and put them into another column.
For example I'll have a list of maybe 2,000 but with only 1-7 different values in the column, what I want to do is populate another column with only the list of the 1-7 values that appear in the larger set.
View 14 Replies
View Related
May 3, 2014
I have a lot of data in column "G" & I need to only remove "<object height=" To "</object>"
See the attachment
View 8 Replies
View Related
Jun 24, 2014
Currently i hav list of info that is long like this.
A 1
B 2
C 3
D 4
E 5
F 6
G 7
H 8
I 9
J 10
How to move row to column example below. Because i want the data to be printed on an a4 paper which can fit around 3 row to save space . If i manually copy paste page by page it is too much.
A 1 D 4 G 7
B 2 E 5 H 8
C 3 F 6 I 9
===
Currently i have macro code which roughly does this.
A 1 B2
C3 D4
E5 F6
G7 H8
I9 J10
Sub test()
Dim rng As Range, m As Integer, c As Range
Columns("c:E").Delete
m = 2
Set rng = Range(Range("a1"), Range("a1").End(xlDown))
Set c = Range("a1")
Do While c <> ""
'MsgBox c.Address
Range(c, c.Offset(m - 1, 0)).Copy
Cells(Rows.Count, "c").End(xlUp).Offset(1, 0).PasteSpecial Transpose:=True
Set c = c.Offset(m, 0)
Loop
End Sub
View 2 Replies
View Related
May 20, 2013
Trying to find the right Excel formula on the example below:
2013 2013 2013
Jan Feb Mar
Ant 0 10 10
Bee 0 0 0
Cat 300 200 100
Where if I was to set the column criteria to "2013" and the row criteria to "Cat" I could return the summed data total as 600.
View 7 Replies
View Related
Jun 11, 2006
I have a set of data (time in minutes) below (fig 1) that I need to use if the total time between two entered times matches a coloms total. If it matches I want Excel to use the data in that colom to affect the data in another (fig 2) colom adding the times to each cell.
Looking at both figs. below I want Row B, Colom A in fig 2 to add Row A, Col A to Row A, Col A in fig 1 since both are the total of 19.
fig 1
Coloms A B C D
Row A 5 5 6 6
Row B 5 6 6 8
Row C 4 5 6 7
Row D 5 4 4 5
Total 19 20 23 26
fig 2
Coloms A B C D
Row A 1:00 2:00 3:11 4:01
Row B
Row C
Row E
Row F 1:19 2:20 3:33 4:27
Row F-A= 19 20 23 26
View 9 Replies
View Related
May 4, 2009
I need to be able to pull the information into another section of the workbook and place it into order (ie Black 1,2,3,4) and then drop down to the next row and place Blue 1,2,3,4 etc. I am using a drop down menu to select the Course, and want the times to then populate to the right, each in its own cell.
Have tried the loop code available on a few different topics here however has not quite worked.
View 12 Replies
View Related
Jan 28, 2010
=(SUMIF($J:$J, "Player1",$K:$K)+SUMIF($L:$L,"Player1",$M:$M)+SUMIF($N:$N,"Player1",$O:$O))-SUM($I:$I)
This looks up if Player 1 was in the top 3 scoring zones and adds up the players total score.
I have another column in this table of data labelled 'Number of Players'. I was wondering how to lookup the total score for this player in the games he played under 6 players for example and the games he played in where there were other six players.
I've tried using that formula ^^ with variations of IF and SUMIF formulas to try and figure it out, but I keep getting formula errors or it just returns with the total score, and not just with the total score under 6 players.
I am also trying to create a graph of date on the x axis against score to date on the y axis - everytime I try, the x axis is always numbers instead of the date?
View 8 Replies
View Related
Jun 10, 2009
I want it to count and fill in a range in column A until it sees a blank or notices the change in value in column B. In the example below i hope it shows what i need to do. i left the last group without numbers to show that is where it needs to start counting over again. i am basically wanting to count down 1st place 2nd place etc.
View 8 Replies
View Related
Jun 6, 2013
Any way to search for a value down column A, another value across roW 1, and tells what value lies in the cell at their meeting point. 4 example, I'm looking For "47" somewhere in column a, and also the number 53 somewhere in row 1, and I need to know what value is in the cell where those to meet.
View 1 Replies
View Related
Jun 12, 2014
I've done some searching and cannot find the right answer for my question. I need to create a formula that will pull column header text data based on cells within a table that contain a numeric value not equal to zero. The catch is that I cannot use any one specific numeric value as the basis for a Lookup.
I've attached an example spreadsheet for reference. Basically, I need two formulas:
1. Formula to pull column header (Receiver name) based on Sender. This is a necessity.
2. Formula to pull individual lines for those senders that have multiple receivers (Division D in my example).
My actual data file has 80+ senders and 100+ receivers.
View 6 Replies
View Related
Aug 5, 2013
I have a list of dates in this format (7/20/2013) that go through several months. I would like to make have a formula that takes all of the dates from a specific month out and make a new list of those days. For example, if I have 7/20/2013, 6/28/2013, 8/3/2013, 7/1/2013. I would like to to take only the dates from July and put them in a new list: 7/20/2013, 7/1/2013.
View 3 Replies
View Related
Apr 28, 2014
Is it possible to have a column count up if two other cells meet criteria?
What I would like to happen (if it is even possible) is, if cell B1 equals CO and C1 is a duplicate, then G1 enters #1 for the first time it is duplicated, #2 for the 2nd time it is duplicated, etc.
Is this even capable of happening.
I am attaching my spreadsheet (TAB "AG Orders"). I filtered the spreadsheet so you can see an example of what I am looking for. I manually typed in column G but I was hoping these numbers could automatically populate.13-14 budget-AG test.xlsm
View 9 Replies
View Related
May 9, 2014
How to do what I am about to ask takes time and time causing brain overloading. I have made screenshots but I can't upload them. I get red exclamation point with images sizing ~55KB
View 9 Replies
View Related
Jul 1, 2014
I've been writing a UserForm in Excel that serves the purpose of a front-end contact/reporting spreadsheet.
I've managed to get a multitude of elements to work together as of yet, however have been having problems writing data to the correct place on the spreadsheet.
What I've already achieved:
The first interactive portion of the userform currently has a TextBox (ArtistAgentAddEmail) - this is the email that we would like inputting on the spreadsheet.
a ComboBox which is populated on 'Userform_Initialize' into an array (ArtistAgentAddDestination) - The range of this array is A1:AC1.
[Code]......
What I would like to do next:
The issue that I've been having is getting the email to be written into the correct column. Once I have typed in my email and chosen my destination from the combobox, I would like to write this email address in the column of the destination chosen.
E.G. The first 5 elements of my ComboBox array are: Neil O'Brien, CAA, CODA, ITB and PRIMARY. If i got an email from somebody in the CAA organisation to add a new contact to the reporting, I would like to be able to add this address via the userform underneath the previously added contact.
The code that I am currently using for my confirm button is:
[Code].....
Attached File : Userform Contact Sheet - 27th June.xlsm
View 2 Replies
View Related