if a1 is bob, b1 is james, c1 is ricky, and d1 is a ssn#(123-45-6789), how do i combine the first charactersos a1, b1, and c1 and the last four of the ssn so that it says bjr6789? ...
If A1 is [Jones,Mike], how can I get it to seperate but still use the first name as text in the other cell? Yes, text to columns would work greatly, but it does let me use the first name in a formula. ...
Let's say I have column A and Column B. Cells in Column A contain either "Y" or "N". How can I set the value of the cell in the corresponding row in Column B with a formula that detects if the cell's value = "N"? Not new to programming logic but to Excel formulas, thanks for your help. -Ryan ...
Hello, here is my dilemma. I have two worksheets one that has the name of clients and one that i want to copy the names to depending on the city. For instance: associated to each column is last name, first name and city. i have hundreds of names associated to different cities and what i would like is from worksheet1.xls to copy all the...
I have two columns with the format [$-409]d-mmm-yyyy;@, I want to calculate the difference of date of these two columns. Please help. Thanks ...
I am trying to make a C# Excel add in change the parameters of an array formula in-place; i.e. do the same as a user modifying an array formula and hitting ctrl-shift-enter. Setting the activeCell.FormulaArray property does not achieve this; it throws a 'You cannot change part of an array' error. Does anyone know how I can achieve this...
I have a master sheet that has rows of house address data, one column of which is a "State" column. I have 50 other sheets in the same document, corresponding to each of the 50 USA states. What I want to happen: When I enter an address in the master sheet, and enter a state (say "CA" or "California"), I want it to automatically populate ...
AU-contains numbers from 0-20 AV-needs to have high, moderate, low; based on the number in AU =>5 HIGH 3-4 MODERATE <3 LOW Wrote this below, however I get #NAME? for the answer; so I know some part of it is wrong. Please help. =IF(OR(AU>=5),"High",IF(OR(AU<=4.9>=3),"Moderate",IF(OR(AU<3),"Low"))) ...
I have 7 columns that have a yes or no in them (N2-T2). I need an equation that will place a 1 in "AI2" if there is a yes in any of the N-T cells. In my previous work with Excel I have only used the colon in an equation if I am adding the cells. Is this correct or does it have more use? I tried the equation below and I get an error; #Va...
Hi, I have to Excel tables. They are sorted after one attribute. Now I want to compare these tables. The problem is, my tables don't have the same values. e.g. Table 1 1 2 3 4 5 7 9 table 2 1 3 4 5 6 7 9 if I try to compare these fields hardcoded (IF(A1=B1;x;y)) i have some missing rows as soon as I get to 3 in Table2. So how am I abl...
I have 3 ranges of numbers and the answer depends on the range. 75-79=0.255 80-84=0.327 85+ =0.559 I tried to create an equation that accounts for the ranges, however excel states that I have entered in too many arguments for this function. Below is the equation that I entered that is not working. (X2 contains the number) =IF(X2=7...
I have an excel file that is a SEO report of a website. But the tool that generated the report included everything under the sun and most of it is junk. I want to filter out the important info such that I keep only records in the first worksheet that correspond to a record in a second worksheet. Basically I want to keep all the records ...
I am looking to take the hyphen or dash out of a birthdate. 01/01/01 01-01-01 I need to combine the birthdate with other fields and it can't have the seperator in it. I am sure there is a better way. I can get the month and year out, using left & right however I can't figure out how to get the middle out. Below is what I have so far and...
Hi everyone, I have a question about Excel! I hope that isn't too unconventional for this site... So I have an Excel table with several thousand rows. It is kind of setup like a db in that the first three of my four columns have numerical values identifying the sequence or order that the content or fourth row contains. I am running int...
Hey all i am trying to figure out how to go about calculating this formula from an Excel 2007 fx to javascript: =(B12*'ROI endo only'!B5)/(1-(1+Data!B12)^(-Data!B13)) WHERE B12 = 0.49% B5 = 99,500 B13 = 48 So far i have this as my javascript code: var theCalc = (0.49 * 99500) / (1 - (1 + 0.49)^(-48)); alert(theCalc); ...
Hey again everyone. Yet again i am having some problems with trying to get the match correct on this Excel Spreadsheet to JavaScript conversion. Here is the excel formula: =IF(IF($B$7=TRUE,$B$28/$B$10,$B$28/$B$5)>1,1,IF($B$7=TRUE,$B$28/$B$10,$B$28/$B$5)) WHERE B7 = TRUE B28 = 76800 B10 = 892015 B5 = 999500 And this is my Jav...
I have a grid something like this: A A A A A B C C C C C B C C C C C B C C C C C B C C C C C B C C C C C Each A and B are numeric values derived from creating a bit array from some other work going on elsewhere in the worksheets. In C, I need to perform a bitwise AND on the intersecting A and B and test if the result is greater tha...
Hi all Basically I have a table like this: Week | Value 1 | 2 2 | 3 2 | -1 2 | 1 2 | 1 3 | 4 3 | 2 6 | 4 7 | 1 I need a chart to show the sum of the values for each week only if the value is greater than 0... so for week 1 --> 2 ...
The first three columns exist. I am trying to create a formula for the fourth (HH_ANALYSIS_FLAG). ACCOUNT_NUMBER HOUSEHOLD_NUMBER ACCOUNT_ANALYSIS_FLAG HH_ANALYSIS_FLAG 1001 1 1 0 1002 2 0 0 1003 3 1 ...
This one has me stumped. When I set the formula for a selected cell in a ListObject, if the ListColumn is empty, Excel fills the formula for the whole column, rather than just the Selection. I have duplicated this in a separate workbook. Create a Table Insert a five or so rows Click on (select) one of the cells in the column Execute ...