Formula To Pull Number From Another Spreadsheet
Mar 29, 2014
I have WorkbookA that pull numbers from WorkbookB. In Cell D2 of WorkbookA is the name of WorkbookB. The data to be pulled from WorkbookB is in Cells H364 through S364, H being data for January and S being data for December. In January, the data from Cell H364 is pulled into WorkbookA. In February, the data from Cell I364 is pulled into WorkbookA, and so on.
The formula can be written such that, based on WorkbookA indicating in Cell B14 the current month, each month pulls the correct month's data from these cells in WorkbookB.
View 14 Replies
ADVERTISEMENT
Nov 11, 2008
I am trying to pull a value (text) from another spreadsheet corresponding with a number. I can't use vlookup because none of them are in a left column. HEre's an example:
there are 2 columns with names and percentages. I am trying to pull a name that corresponds to a certain percentage.
View 3 Replies
View Related
Dec 5, 2007
I am trying to create a formula to pull the person's name and the avg number of cartons sorted for the month from this spreadsheet.
I've attached a sample of the spreadsheet I created, you will see at the bottom I would like to see the person that had the highest avg for the month and the person with the lowest avg for the month.
This is just a simple spreadsheet to track productivity of my sortation employees.
View 9 Replies
View Related
Sep 12, 2013
Formula to pull the lowest number that falls in Cells I2:L2 and the number must be 0 or Greater. Some of the numbers might be negatives and I am trying not to pull those numbers.
View 3 Replies
View Related
Jan 7, 2010
I have a column of numbers each have a 0. infront of them (example 0.2346
0.5698). I want to pull the number from the right until it hits the decimal sign. So for the two above the result would be 2346 and 5698
View 2 Replies
View Related
Jul 7, 2014
I have a workbook with a spreadsheet that will have ID numbers entered into it. In the column next to the ID numbers, I would like to have usernames automatically populate. I have another workbook that has a spreadsheet with one column with user ID and one column with the username for that particular ID number. Is there a formula I can use to have Excel match the user ID entered to the user ID on another spreadsheet, and then pull in the column next to it (the username)?
View 1 Replies
View Related
Jun 28, 2007
I have a complex data set that has been imported into Excel from a binary data file and I am looking for a way to simply pull out specific fields. I tried to record a Macro that would simply delete the rows between the data rows I want to keep, but it always references itself to those same ranges and I'm not sure how to identify that I want it to sequentially move down the page deleting the same number of rows, and adding the row of information I want to keep as it goes.
View 9 Replies
View Related
Feb 7, 2008
I have two spreadsheets, i suppose one part of the solution may be to copy spreadsheet 2 into a new worksheet in spreadsheet 1, but this is my current situation:
Spreadsheet 1 has "Employee lastname" in column F, "Employee Firstname" in column G. Column A in this sheet needs updating with the data populated in column H for that employee in spreadsheet 2 - the lastname is contained in column B, firstname in column C - so i need to to a match.
View 12 Replies
View Related
Jan 23, 2012
Workbook 1 has 2 spreadsheets. Spreadsheet 1 contains Item and Pass/Fail Columns. under the item column is the serial number of the item tested. the Pass/fail column has the serial number duplicated if it failed tested. what is the formula is to have spreadsheet 2 pick the items from the pass/fail column on spreadsheet 1?
View 4 Replies
View Related
Jan 4, 2010
I have attached a document paralleling a document I am working on. The dollar amount in each spreadsheet represent sales. I have entered in values into the candy, soda, and chips spreadsheet. I have also linked values for candy into the total spreadsheet. My question is can I somehow type something or drag the formula down to populate the other cells in the total spreadsheet?
The idea I am thinking but which I don't know how to implement is to list all the items (as in column G) and list all of the relevant cells (e.g. B1 in the Candy spreadsheet) as in columns H and I (Note that all items will have the same cells but the cells will have different values...e.g. all three items have a cell B1 and B2 in their spreadsheet but these cells contain different values). I then try and fail to create a formula in cell B3 of the Total spreadsheet. I am trying to create a formula of the following nature:
='(Spreadsheet Name From Column G)'!(Cell Name From Columns H and I)
The Second half of the formula doesn't really concern me (i.e. the cell name from column H and I). However I am perplexed as to how to achieve the goal in the first parentheses above.
View 4 Replies
View Related
May 31, 2013
I have a spreadsheet that has item names and then at the end the manufacturer number. I'd want to find way cut that manufacturer number off the end and move it to its own column.
I pasted some examples below of what it looks like. It is just coincidence that the items below all that the same length...they are all of varying lengths. The one thing they all have in common is that it the last thing in the cell and seperated by a space. I would think there would be a way to find the last space in the cell and cut everything to the right of that. I can do it in a macro if necessary, but where to start.
AVENGERS FIGURE ASST 3 75 A1816
AVENGERS HULK HANDS A1827
AVENGERS SLAMMERS A1822
BATMAN BATMOBILE Y1258
BATMAN DK KNIGHT FIGURE ASST Y7572
BATMAN FIG N VEHICLE ASST Y1252
View 3 Replies
View Related
Apr 3, 2012
I have two formula i use to pull out the number from text in a cell (J2), the problem i am having is that it will only pull out numbers up to 99,999 and i now have numbers over a million in some case that i need to report on.
I have two way I have been doing this see below, how can i change them so they will pull the number over a million?
I am sure it easy but i have tried all sort and i can not get it to work...
=LOOKUP(100000,--MID(J2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},J2&"0123456789")),ROW(INDIRECT("1:10"))))
OR
=LOOKUP(99^99,--("0"&MID(J2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},J2&"0123456789")),ROW($1:$10000))))
View 7 Replies
View Related
Jul 16, 2012
I'm trying to pull a specific 10 digit number from a text string. The ID # is always 10 digits however sometimes there are dates in the data that need to be excluded as well as other numbers such as "I-9". The 10 digit number will always start with 1 or 8. Is there a macro or Formula to extract this data? Please find the example dataset below.
Edit: I should specify I want the "100118416" number from the first cell example or the "800011320" number from the 10th example.
NDM Abxx, Kexxxxx 100118416 2-29-12.pdf
VPG I9 Aberxxxxx, Dexxx 100113048 1-1-12.pdf
I-9 Abxxx, Rexx 100119966 4-5-12.pdf
NDM I9 Achxxxn, Paxx 100119008 3-15-2012.pdf
VPG I-9 Acxxxxx, Toxx 100112782 01-01-12.pdf
[code].....
View 9 Replies
View Related
Feb 19, 2010
(the html is messing up the out put for a2 and a3)
I am trying to get the total amout that is in the set in individual cells. I have the size type done just having trouble timesing the numbers in the cell
Example.
A1 A2 A3
10/2LB/CASE 20 Pound
12 16 OZ CASE 192 OZ
12/750ML/CASE 9000 ML
5 Gal/Box 5 Gallon
(i have placed the columns to match formatting normal=A1 Bold=A2 Underline=A3)
View 9 Replies
View Related
Feb 13, 2008
In a1 i have 100.888 and a2 122.222 and a3 122.555UK,(and so on) in column b i want just want the number and not the uk, i have tried =left(a1,7) which works until a3 then it give me characters 122.555 and not the number/value 122.55. I need it as a value to use the vlookup, how do i do it?
View 3 Replies
View Related
Oct 26, 2012
I have Put 15 Digit Number 234567890123456 in Cell A1. I am trying to get each Digit Seperately into Single Cell from B1 to P1.
View 5 Replies
View Related
Mar 24, 2009
I would like one formula to remove "5206" from this string. I tried a combination of right/left formulas together, but I could not get it to work.
5032.5206.05816.00040501.0000
View 9 Replies
View Related
Aug 21, 2008
Attached is the sample file.
Basically I have a number in column A, just wondering is that any faster to allocate the number into individual cell as shown in the attached file.
View 5 Replies
View Related
Nov 8, 2006
I have 2 worksheets (Sheet1 and Sheet2). Sheet 1 contains around 3000 records with multiple fields (columns). Column A contains the ID number. Sheet 2 contains some records with different fields except for the ID number which is common.
I need a macro to retrieve information from sheet1 and copy it to sheet 2 based on the ID Number; i.e the macro needs to get the ID number from sheet2, locate it in sheet1 and copy the data from column D in sheet1 for that particular record and paste it in sheet2.
View 7 Replies
View Related
Apr 10, 2008
I am having an issue with formatting a cell to 'general'. I have a macro that runs using a formula (i.e. =MID(A12, 18,5)) to extract certain characters from an external data source. I then use only the values of that formula. There then is another macro that compares that value to another value in another worksheet. The issue I am having is when the macro runs, the code is read as ActiveCell.Offset(0, 3).Value...but instead of returning the value in 'general' format, it returns it with what appears to be text (i.e. "75.50" instead of 75.5). This acts as a mismatch since the quotes appear.
I have attempted several things to correct, but even if I try to format-->general it maintains the quotes. The only way it changes is if I click within the cell...then it turns to general (i.e."75.00" becomes 75.5). I am not sure what is the issue.
View 2 Replies
View Related
Aug 26, 2009
I am trying to do season stats for my roller derby league. I have a great spreadsheet going but the one thing I want to do, I can't seem to do. I am attaching a "test" file. very simple and small but shows what I need to do.
I have different sections and I am trying to pull the highest number out of that section. For this example, it is under the green Jams Skated: Jams at Jammer. The number on the right is the highest number of jams skated while the number on the left should be the name of the skater who has this number. Okay, no problems there. My problem occurs when I try to move these same formulas to another sheet. in this case, sheet 2. It pulls all kinds of strange things.
View 4 Replies
View Related
Oct 14, 2008
I need to pull a reference number and assign it to all records in a particular section. The code I recorded keeps going back to the first section. Also would like it to repeat until all records have the reference number attached.
06010-100Beginning Balance07/09/2004AD06011-10007/23/2004AD06011-10008/06/2004AD06011-100
06011-100Beginning Balance07/09/2004AD07/23/2004AD08/06/2004AD
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/14/2008 by acantu
'
'
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Range("C7").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B7").Select
Selection.End(xlDown).Select
Range("C63").Select
Range(Selection, Selection.End(xlUp)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.End(xlToLeft).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
End Sub
View 9 Replies
View Related
Jun 10, 2008
What formula or function truncates a text field that is in the following consistent format:
number. name
ie. 3. Super Bella
and 150. Taoist
I wish to truncate the field so I have just the integer without the dot, space or word(s).
Tried Len, Left & Replace but they require a specific number of characters. Since the number can be 1 to 3 digits long, this doesn't work.
View 3 Replies
View Related
Feb 7, 2010
I need to create a formula that will automatically give a ranking based on where the revenue lands in between. If its between the range then it gets an A-F ...
View 9 Replies
View Related
Apr 15, 2014
I have a list of project numbers in column "J" and i need to pull the first six digits of the project number to column "O"
View 4 Replies
View Related
Jun 15, 2009
If I have a columns of numbers that vary in length, and can have empty cells between the final value and the formula to pull the number (of varing lengths), what formula can I use to repeat the final value?
For example - here are two columns:
4,800,000
0
46,594
space
space
<formula to pull 46,594>
or
56,000
48,150
36,528..............
View 2 Replies
View Related
Aug 13, 2014
The below is an example of some data I have in a workbook ...
Basically I need a formula to look through the data and search for any fails within Column A then I want it to pull the Reason
The Pass / Fail could appear anywhere within the range and we will only get a reason for any fails
A B
1Result Reason
2Pass N/A
3Pass N/A
4Pass N/A
5Pass N/A
6Pass N/A
7Fail System Error
8Pass N/A
9Pass N/A
10Pass N/A
11Pass N/A
View 2 Replies
View Related
May 27, 2009
i have a table with year and day in rows and months as columns. I'm looking for a formula that will look up a number in that table based on the date given in colP and put the number in Q. See example.
View 2 Replies
View Related
Apr 23, 2014
I am trying to have my spreadsheet pull data from one tab and cell if they match another.
Tab "Ag Orders" column H, I enter data in lets say cell H37. Whatever I enter, if it matches tab "reference List" C:C, then "ag orders" column G (specifically G37) should enter the data in "reference List" D:D
So since in H37 I entered 34000 - 314620, G37 should pull in Farm Operations since on the referene list tab that string of numbers (C11 matches up with D11)
a little confusing but I hope it makes sense.
13-14 budget-AG.xlsm
This isn't the exact formula I used but something like it and it wasn't working. It wouldn't match the data up correctly on a few of the department names
=IFERROR(LOOKUP(H35,("11000 - 311010","11000 - 311020","11000 - 311510","11000 - 311610","11000 - 312010","17800 - 311010","17800 - 311510","17800 - 312010","34000 - 314610","34000 - 314620","34000 - 314640","34000 - 314660","34000 - 314680","34000 - 314690","81008 - 840008","81009 - 840009","13863 - 312040","13864 - 312050","71060 - 521620"),
[Code] ..........
View 1 Replies
View Related
Jun 14, 2014
Looking for formula to extract data from the raw data table list to a new table list when an option is selected from the dropdown list.
Sample data attached and desired outcome in green color.
Outcome
Product 3
ProductTargetOff TargetTarget Range
January364980
February135732
March162167
April
May
June
July
August
September
October
November
December
View 3 Replies
View Related
