Recognize Conversion (word To Number) And Multiplication Factors?
May 20, 2009
I'm trying to make a table of the total amount of a liquid used throughout the day. Here is what I am trying to do: In cell D4, I want to be able to enter something similar to the following: 3cup+2bottle+1liter
and by doing so, Excel can automatically recognize that 1cup is 8oz, 1bottle is 17oz, and 1liter is 34 oz because of the reference chart provided on the side. Also, it would be able to notice the 3, 2, and 1 amounts so it would multiply accordingly so it would know to do this: (3*8)+(2*17)+(1*34)
and then put the calculated amount in the cell. The correct answer should be 92oz. Is there a way for Excel to recognize the conversions (i.e. whenever it sees 'cup' it will multiply by 8) and multiplication factors (i.e. 3, 2, 1)?Is there a formula I can enter that I can just "drag" down to the upcoming days in column D?
I know I can just do something like this: (3*G4)+(2*G5)+(1*G6).
View 2 Replies
ADVERTISEMENT
Nov 4, 2009
I have a spreadsheet where I want to record the VO2max value (a number indicating the maximum volume of oxygen a person can utilise) of a person.
The VO2max is just a number, normally between 30-60.
I then need excel to look up the VO2max value (i.e. “35”) and give that number a predetermined inputted value name in a different cell (i.e. “low” or “fair”, “good”, “very good” etc etc).
However, as VO2max is also affected by age and *** I also have a column for the participants age and *** and I want excel to use that to make the value name.
E.g. in a 24 year old male a VO2max of 32 is “low”
But, in a 42 year old female a VO2max of 32 would need to be classed “”moderate”
Any ideas how this can be done? can it be done?
I could post the table containing the age range, values and names if I knew how to post an excel sheet on here.
View 9 Replies
View Related
Dec 19, 2009
I've been looking on the internet for a spreadsheet that lists the various units of measure with conversion factors to other units. I'm not looking for the formulas, just a chart.
View 3 Replies
View Related
Jan 20, 2009
I have a spreadsheet with early retirement factors;
Years early
1 93.5%
2 87.6%
3 82.3%
4 77.4%
What I'd like to know is if there is an easy way to work out the factors for 1 yrs 1 mth early, 1 yrs 2 mths early, 1 yrs 3 mths early, etc.
View 2 Replies
View Related
Apr 5, 2014
I'm trying to make a spreadsheet template that will find and replace all instances of a given word with a bold or highlighted version. However, I do not know how to make this process passive and automated. That is, as soon as I type certain words, they should be auto-corrected. Is there a way to set excel so it will recognize certain words and replace them? Is there a way to do this in the settings? I don't think a macro is the right answer in this case, so I put it in the general thread.
View 5 Replies
View Related
Jan 29, 2010
Searching through the forums, I've found a post of daddylonglegs, witch shows how to find the smallest factor of a number:
View 7 Replies
View Related
Aug 5, 2009
This is kind of an extension to a previously solved post. For a similar problem I used the attatched file (which someone from here so kindly came up with - but to be honest i dont fully understand),
but now im getting onto numbers from 1 to 100 so could get very confusing in the table!
RANDOM TABLE2.xlsx
Basically I want to produced a random number, (which I have managed) then another number, but it cant have any common factors as the first.
So 1st = 10, 2nd = 13 is acceptable
but 1st = 22, 2nd = 12 is not.
I have managed to do it with smaller values by just typing then out, but this is a very long winded technique, but is there a formula that can do this?
View 8 Replies
View Related
Dec 28, 2009
In the given example below how can i recognize the last number which is LV-00010 and after recognizing the last number i wanted to add 1 so the next number will be LV-00011 (im using this as an automatic ref. no.).
LV-00007
LV-00004
LV-00010
LV-00008
LV-00009
LV-00001
LV-00002
LV-00006
LV-00003
LV-00005
View 9 Replies
View Related
Jan 28, 2010
How can I make excel to recongnize this: 123456- as a negative number?
View 7 Replies
View Related
May 16, 2013
I want to automate the Display labels in my Charts using VBA Coding…
I would need to use this small code in Charts with different Scales as some of the Scales in my Data are in a very large Range close to Trillions so its not possible to have these as the Primary-Y-Axis Scale and therefore I would need to use the in-built Display label option which Excel provides..
However, I always prefer to have the scale in the Range of Thousands so the Max I can have in the Scale can be 10,000 so if there is any Number more than that or the Scale is going above than I would prefer that this gets auto-calculated to Multiply with the remainder and show appropriate Scaling.
For Ex:In this example My largest Number is 4500000000 which is 100 M..So I would want the scale to show 4500 and the Display label as X Millions..
So The Display Label would be different for different Ranges but the Max Scale preffered would be 10,000.
View 8 Replies
View Related
Mar 9, 2007
I have the following column:
A1 B1 B3
Ab123 1278 what i would like is if cell A2 start with AB then B1 and if not then nothing
AC125 1587
AF123 1365
AR125 1259
I would like another cell to check the cell where i have the two letters and the numbers. if the cell start with the number that i am intrested then to confirm it to me, or to give me a value from another cell.
View 10 Replies
View Related
Aug 26, 2009
I have two sets of data that I need which is obtained from one source.
Basically, the stats I am working with in excel are Processing Time (minutes/seconds) and Volume Per Hour. I desperately need a formula that will allow me to convert the processing time into Volume per hour.
Example: Average Handle Time, 7min 7 seconds = x per hour. If it was just 7 minutes flat I could simply divide that into 60. I also can't make it 7.7 and divide that because 7.7 doesn't equal 7m7s.
Does anyone have any thoughts on a way to do this? I found a conversion chart online that allowed me to do this work manually 'Conversion Chart: Fraction of an Hour to Minutes', but I haven't determined a way to make a formula out of this.
View 9 Replies
View Related
Jul 29, 2009
Basically I have a phone number in column A:
123-456-1234
In column B, I want it to show me the first 3 numbers from the left, (so 123)
So I do =LEFT(A2,3)
Which gives me 123, but it's displayed as text, which ruins my whole formula that looks up the area code and displays the state.
I googled the problem and found http://exceltip.com/st/Make_LEFT_Fun...umber/778.html
which tells me to do:
=IF(LEFT(A1,1)=1,"Ignore",A1) [sees 1 as a number]
=IF(LEFT(A1,1)+0=1,"Ignore",A1) [sees 1 as a number]
=IF(LEFT(A1,1)="1","Ignore",A1) [sees 1 as text]
but when i try that it just displays the ENTIRE phone number: 123-456-1234
View 3 Replies
View Related
Oct 24, 2008
I'm trying to figure out a formula to be able to look at a column of txt and if it finds the word total it need to output the number at the column next to it. If the word total isnt in the text then it should leave it blanks (see below). Basically I want a column that pulls only the totals amounts in the column.
Aaron Drielick 3
Aaron Drielick 2.5
Aaron Drielick 37.5
Aaron Drielick Total 151.0
Akila Subagaru 31
Akila Subagaru 1.5
Akila Subagaru 1
Akila Subagaru 1.5
Akila Subagaru Total35.0
Albert Major 4
Albert Major 6.5
Albert Major 2
Albert Major 19.5
View 3 Replies
View Related
Aug 24, 2009
Over the weekend I had to look at 220 strings of numbers, some strings with as much as 20 numbers and determine if the numbers represented red, green, blue, or yellow and how many of each color from a parent list.
I did it all by hand. After getting help here from JBeaucaire on my tally sheet, which I successfully recreated with their guidance, I thought I might ask this question. How would one go about creating a macro that would when it seen a certain number, it would put the color in the column immediately to the left, and the number of colors in the column immediately to the left.
View 6 Replies
View Related
May 7, 2006
I'm trying to convert a number from word to a number in excel. Example: 10-12 input in word to a cell in excel. Unfortunately it treats it as a date an gives me 39002. I want to be able to use both numbers and add them together to get -2 not 39002. How to format the excel spreadsheets in order to complete this calculation.
View 4 Replies
View Related
Aug 15, 2006
I have a spreadsheet which I automatically generate using VBA. One of the columns lists account numbers. After the macro is complete, the account numbers are non-numeric and left justified. However if I select one of the account numbers by clicking on its cell, and then edit the account number in the formula window, it changes the cells property to numeric and right-justifies the cell.
View 6 Replies
View Related
Dec 3, 2007
I have 2 sheets;
Sheet1 (Also named "TicketNames") and Sheet 2 ("Day1").
On TicketNames I have 4 Columns the first 3 columns with about 5 names per columns.
Each list of five are given a specific Name ("One","Two","Three"). The last column is just
a list for Day1 dropdown menu. (3 names, "One", "Two", "Three").
On Day1, I have a validation list on A1 which will allow the user to select either ("One, Two or Three").
On B1, another dropdown menu, but it will only show the items related to the selection they made on A1.
My problem is that on A1, instead of having "One" show up, I want it to say "$1" for One dollar. But because it is a number not a text it won't allow me to use a validation list using this.
I'm using Excel 2007
View 14 Replies
View Related
Jun 9, 2009
Have problems using find and the Dictionary
What Im trying to do is find a certain word in a string then return the number associated with that word
View 7 Replies
View Related
Jun 16, 2014
Using the text to columns option on a comma separated file in csv format leads to the right preview in the text to columns wizard.
The column titled "ATTIC: Zone ..." shows the desired format in the preview window. Please look at the screenshot 1.jpg.
After pushing the finish button to obtain the result the number format gets suddenly changed and differs from the preview.
Again check for the "ATTIC: Zone ..." column as reference: 2.jpg
Is there a menu where one can look up, or specify how to format data to force the right comma placement? What settings might be wrong?
View 3 Replies
View Related
Jul 31, 2014
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies
View Related
Jun 3, 2014
I have on the first tab a screen where you can fill in the name of the .doc or .pdf file.
That works fine, but now I would like that when I fill in a number and click on test, it opens te .doc and .pdf file that is attached for that number.
If you take a look at the pdf file you will see a second and a third tab.
First column is the number they need to fill in and the second column is the name of the .doc or .pdf that needs to be opened with that specific number.
How to link it and open both files for that specific number.
But not every number has a .doc as well as a .pdf.
View 5 Replies
View Related
Jan 26, 2012
I have the data below. I need to total the amount in the USD Equivalent column but there is an exception. Where the "Curr Sold" and the "Curr Sold" are the same in reverse (as highlighted) in yellow, I need to take the net figure. For example below, I need to add the USD Equivalent column but then minus the 6,013,072.66 because the CHF - USD is the same in reverse with the same maturity date.
Maturity DateCurr SoldAmount SoldUSD EquivalentCurr Bought
09/03/2012USD4,000,000.004,000,000.00EUR09/03/2012USD3,500,000.003,500,000.00CAD
09/03/2012USD7,535,000.007,535,000.00CHF09/03/2012CHF5,578,989.356,013,072.66USD
09/03/2012USD2,500,000.002,500,000.00EUR09/03/2012USD2,500,000.002,500,000.00CAD
09/03/2012USD5,000,000.005,000,000.00AUD
View 1 Replies
View Related
Dec 7, 2012
I have to make a hierarchy of my employees, taking in consideration the achievemnt of their target. I'll attach a sample to make it simple to understand. The are 2 classes of factors: Class I and Class II.
- In Class I (witch counts 75% in total results) there are:
- New deposit - count 75% from class I
- Insurance - count 10% from class I
- Investments fund - count 15% from class I
- In Class II (witch counts 25% in total results) trere are:
- Loan A - count 15% from class II, but the number have a weight of 40% in results, and volume 60%
- Loan B - count 75% from class II, but the number have a weight of 75%, while volume have 25%
- New clients - count 10% from class II
Now, I have to rank the employees taking in consideration the Deviation for all of the factors above (columns E, H, K, P, Q, V, W, Z).
View 3 Replies
View Related
Nov 4, 2011
I need to count, not list, all of the factors of an integer. For instance the number 12 has the following, 1 2 3 4 6 12, so the solution to the NoF(12)=6.
View 9 Replies
View Related
Apr 9, 2014
I have a big list with names, money spent and date. I need somehow with a formula to do:
Take all the money spent on some specific day from a specific person an put it into a field.. and this for every date of the week and for everyname... Im gonna upload a photo.
Name
Money
Date
Daniel
5
01.03.2014
[Code] ........
I need the list of the left to produce me list of the right somehow, at least just the sum of everything spent everyday.
View 7 Replies
View Related
Jul 10, 2014
I want to get the sum of the multiplication of two columns. Why the macro is needed?
Because I want always to multiply the first column with a series of column combinations. At the end I want to get a number for each case.
Example.
I have 4 columns (this can vary). I want to perform:
A*B, A*C, A*C, A*(B+C)
View 4 Replies
View Related
Oct 6, 2012
what i am trying to do is multiply the numbers in two seperate cells on the same row (e.g. C1*D1) and do this for the whole column where there is data (so it could go down to (C9*D9)
I was wondering how I would execute this in a macro, I am also looking to show the total value of all these added together but one step at a time
View 8 Replies
View Related
Feb 19, 2009
As I have illustrated in the example below, I want to multiply a value by 1.(something). The 1. is always constant, where the I8 cell is variable. I can't get this to work.
=H15*1.(I8)
View 9 Replies
View Related
Jul 8, 2006
I have a worksheet with many lines of inputted numbers (values). I want to divide each number in the sheet by 4. However, I don't want to move any of the numbers because other sheet in the workbook refer to these cells. Does anyone know how i can do this easily?
View 3 Replies
View Related
