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

Pulling Over Data With Specific Criteria?

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

Pulling Data That Matches A Specific Date?

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

Pulling Specific Data From Random String

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

Pulling Rows Of Data Based On Criteria In One Column?

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

Pulling Data To Separate Sheets Based On One Column

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

Macro To Extract Data From Specific Column To New Sheets Specific Column?

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

Trying To Pulling Specific Items From One Sheet

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

Pulling Specific Rows From One Sheet Into Another In 2007

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

If Column Contains Data Then Insert A Blank Column And Shift Specific Column To The Right

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

Pulling Values From A Column And Reordering Them In Another Column Without Spaces

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

Pulling Info From Column

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

Pulling The Last Number From A Column Of

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

Getting Rid Of Specific Column Data

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

Specific Data From A Column

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

Pulling Specific Text Within Text In Which Information Is Typed Differently?

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

Pulling Unique Values From A Column

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

Remove Specific Data From A Column

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

Move Specific Data From Row To Column?

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

Sum Row Data Given Both Specific Column And Row Criteria

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

Use A Column Of Data If A Specific Value Is Found

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

Pulling Items From A Multiple Column Range

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

Looking Up A Sum Of Data In Several Columns For Specific Values Of Another Column

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

Counting Cells In A Column With Specific Data

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

Finding Data By Specific Values In A Row And Column

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

Pulling Column Headers Based On Table Values (not Max Or Min)

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

Pulling Specific Dates Out Of List Of Dates?

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

Automatically Have Column Count If Two Other Cells Have Specific Data?

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

Sort / Move Data In Accordance To Specific Column?

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

Using ComboBox Array To Write Data To Specific Column?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved