Multiply A Column And Result Appear In Next Column

Aug 31, 2010

How do you multiply a column and have the results reappear in the nextcolumn? E3:E3631*1.3 = F3:F3631, is the code I tried.

View 3 Replies


ADVERTISEMENT

Multiply Every Nth Cell By Another Column Whith Merged Cells, THEN Find Column Total

Aug 6, 2009

Please see the attached sheet. I have columns B through a lot (B through O in my oversimplified example). In every 7th row in each of these columns there is either a 1 or a blank/zero. I need to multiply that 7th number by the Quantity in column A, to achieve a total (ie the sum of each result of 7th cell*quantity) for each column in the bottom row, labeled "Totals".

In the actual version of my sheet, there are far too many rows to select everything manually. I've been fiddling with combinations of COUNTIF/COUNTA and OFFSET, but I haven't come up with a way to check for the 1 in every 7th row, THEN multiply that 1 by the quantity in column A, THEN add up the results for each column. As you can see, there are 1's elsewhere in the columns that are irrelevant to this particular calculation, so something like LOOKUP would also have to look in every 7th cell and couldn't just look at the column as a whole.

If you can't provide an immediate solution, but can at least point me to a resource that would allow me to devise a way to isolate every 7th row (THAT part is the sticking point), I'll surely post the solution to my own thread with updated keywords if I need it.

View 8 Replies View Related

Formula To Display Column Header As Result When Any Value Exists In Cells Under Column

Jul 25, 2014

I am trying to write a formula where the column header of the row in which a value other than 0 exists, will display for each instance (row) where a value exists in an array spanning 3 columns. So the result cell could be any of the three column headers, or a combination thereof.

I started the formula in P2 of the GL Detail-2012 tab. File attached.

Here is what I started: =INDEX($M$1:$O$1,SUMPRODUCT(COUNTIF($M$2:$O$67756,))). Not working.

View 7 Replies View Related

Capture Unique Values From 1 Column And Populate The Result Into Another Column

Aug 28, 2009

I have values in COlumn A, probably about 50K rows, The total unique values on the column A is only about 27. I need to capture all those unique values and paste them in column B. I didn't want to do "Advance filtering" since the workbook has many macros's on it that the user simply click on. Im thingking of creating a loop and compare values already pasted in Column b but then that will take too much time to complete the loop. Is there any easier or yet more efficient way to accomplish this?.

View 2 Replies View Related

Multiply If Column Contains Certain Text?

Aug 8, 2014

I have column A that declares the account as asset, liability, expense, etc. Some of the accounts need to be reversed. I'm having a hard time figuring out a formula or code I can use. Column C contains the values. I prefer VBA as I want to add it to the current macro I already have.

So if Column A has a liability, offset by (0,2), and multiply that value by -1. If Column A has an asset, leave the value as is.

I wanted to use an if-then statement but I'm not sure how to highlight entire columns. The number of liabilities, and assets, etc.

View 7 Replies View Related

Multiply Column - Final Formula For This Spreadsheet?

Jul 30, 2014

I am having trouble with the final formula for this spreadsheet.

I want to be able to select "Holiday/Sunday" from the drop down men in column H, and have it multiply the total in column F by 2. There is already a formula in column F that sums column E-D.

View 4 Replies View Related

Multiply 2 Values Based Upon Corresponding Column Cells

Oct 15, 2009

I'm absolutely new to Excel and I've been trying to workout a formula to to test two conditions if true and derive the data from a 3rd column. In my attached excel file there's a Grade (A) , Status (B) and Mid Point (C) Tables. I'd like it to be formulated in a sense that forexample:

IF Grade= 1 AND Status= Q4 RETURN =3750*0.25
IF Grade= 1 AND Status= Q3 RETURN =3750*0.5
IF Grade= 1 AND Status= Q3 RETURN =3750*0.75
IF Grade= 1 AND Status= whatever (I mean whatever I input in this cell then it would retrun 3750 ofcourse satisfying the condition grade= 1) RETURN =3750

IF Grade= 2 AND Status= Q4 RETURN =5500*0.25
IF Grade= 2 AND Status= Q3 RETURN =5500*0.5
IF Grade= 2 AND Status= Q2 RETURN =5500*0.75
IF Grade= 2 AND Status= whatever (I mean whatever I input in this cell then it would retrun 5500 ofcourse satisfying the condition grade= 2) RETURN =5500
................

View 7 Replies View Related

Multiply Column Of Numbers By Fixed Number

Mar 1, 2008

I did a search myself, then went through the 5 pages the "Post" function brought up. I'm sure it's been asked before, I must just not be using the right words

I need to tell every cell in one column to multiply itself by a firm number and a percentage. Ex: Column F will be the result of $77.80 times 75 percent all the way down the column. Column G will be $27.21 times 100 percent all the way down.

I could enter the formula into every cell, but I wondered if there's a way to just tell the whole column, only once, what it needs to do. PS-I work for an insurance company. The employees of a company want a spreadsheet showing exactly who pays exactly what. Ex: Their paystub shows $142.90 coming out of their paycheck. Their employer pays 100% of medical, 75% of dental. The columns would show Total, Employer Medical, Employer Dental, Employee Medical, Employee Dental.

View 2 Replies View Related

Multiply Column Of Values By A Random Number Within Range?

Apr 20, 2012

I have a column of values I need to multiply by a random number (percentage) within a range of numbers (15%-22%).

How can this be done?

View 1 Replies View Related

Multiply Two Column Vectors Based On Reference Cells

Feb 9, 2013

How do you multiply two column vectors D2:D6 and G2:G6 based on reference cells A3 and B3 that are equal to D1 and G1?

A
B
C
D
E
F
G

1
2
3
4
5

[Code] ......

View 1 Replies View Related

Multiply Cell In Column A If Cell In Column B Is Equal To 5?

Mar 25, 2014

How can I multiply let's say A1 to 10 if B1 = 5

or multiply next cell like A2 to 15 if B2 = 10

View 3 Replies View Related

Multiply Numbers & Return X Percent Of Result

May 30, 2009

I have an inherited formula and I am not sure if it is giving me the correct answer. It is:

=0.03*668*0.75*0.10
The result is 1.503

What I am aiming for is to get 3% and 25% of 688, deduct the results from 688 and then get 10% of that answer.

Is the inherited formula correct?

View 3 Replies View Related

Automatically Multiply Set Value And Overwrite Original Entry With Result

Jun 5, 2014

I want to be able to enter a value into a cell (within a specified range) and have it automatically multiply by a set value and overwrite the original entry with the result so making it all happen within one cell. The set value would be another cell on that sheet.

So the range for example is "H17:H74" and the value I want to multiply by is "D8"

Is this possible?

I've looked at another forum but it wasn't working when I wanted to define the set value as a cell.

View 5 Replies View Related

Multiplying By 0 But Keeping Existing Result - Conditional Multiply

Nov 10, 2008

I know when you multiple anything by 0 the answer is 0.
But I have a list of numbers I need to multiply out
but want to keep the total even if there is a 0 in the sequence
Eg
A1*A2*A3*A4
10*15*0*11
5*21*6*0
0*14*10*0


So A1*A2=150 if I then multiply by A3 I get 0, but I need to ignore the cells that have 0.
So for the last example my answer would be 140.

View 9 Replies View Related

That Takes From Manual Sheet The Number In Specific Column And Multiply It By The Percentage In Sheet

May 29, 2009

I'm trying to create a formula that takes from "Manual" Sheet the number from colume G2 and multiply it by the percentage in sheet "AllocationRule".

My formula currently is =Manual!$G$2*AllocationRule!$B5.

What needs to happen is that the total number in "Manual" needs to be distributed evenly in 4 rows by the percentages allocated in "AllocationRule".

Right now I can't copy my formula over to the sheet because the "AllocationRule" should stop at B5 and not go further and the G2 from "Manual" should not change for the percentage allocation but should change to the next row for the next month.

And then after I've done the calculation I want the LOB in "AllocationRule" to be displayed in the LOB in "H1913_H1914" but I'm not sure what formula to use.

View 7 Replies View Related

Lookup Value In One Column Result In Another

Jan 26, 2014

In my spreadsheet I have a column (C) that consists of 20 rows. Within this column a calculation is done with only one value (currency) that appears based on the calculation criteria. All other rows are 0 (currency) and the correct calculation can be in any of the 20 rows.

In an adjacent column (say E10) I want the appropriate value to be entered from column C.

View 3 Replies View Related

Sum A Column And Then Display The Result

Jan 15, 2010

I want to sum a column and then display the result but in the same cell put some text:-.....

View 4 Replies View Related

Look Across Row And Return Result Down Corresponding Column

Dec 16, 2009

I need to figure out a formula that will look across a row and once it finds the criteria specified, it will return a value going down the corresponding column. I have attached a file showing the example.

View 3 Replies View Related

Add Number Of Rows With Result In Next Column

Dec 28, 2013

I have been using the following formula to add time (hh:mm) in the last 28 rows (inclusive) of Column B into an adjacent cell in Column C (Column A is the date):

=SUMPRODUCT($B1177:$B1204)*24

It is becoming tedious to copy/paste the formula - Is there a formula that would define all cells in Column C to be the sum of the last 28 rows of Column B?

View 3 Replies View Related

Date Result From Text To Column

Aug 10, 2009

As part of a larger macro, the code below is supposed to start the separation of data into 4 columns. It doesn't work perfectly though and I have to manually inspect data and correct. The problem is that 22: 8- 3- 3 becomes 8- 3- 3 in the second column, which is what I want. However 60:12- 7-10 becomes 7/12/2010. Excel appears to recognise it as a date, when the extra number is in the second column.

View 4 Replies View Related

Function That Will Show The Result In Column AD

Nov 6, 2008

I have a huge worksheet that contains four character payer code in column D for example: 9081, M897, 0235. I am looking for a function that will show the result in column AD

IF payer code in column D starts with a 9 (9???) - GOVT
IF payer code in column D starts with a 7 (7???) or M (M???) - MNGD
IF payer code in column D starts with a 2 or 0 (zero) – COMM
IF payer code in column D starts with either Z, I, C - PTR

I tried IF function, but it didn’t work for me.

View 3 Replies View Related

Data Compare And Result In Another Column

Apr 25, 2012

I have DAta in Col A (Med ID ) and B has number of events assocaited with the unique ID. The Unique ID is also in Col C from another data source. I wnat to return the value from Col B in in Col C that mathces the MD ID if available. There are several more col in the sheet that have other dta that is not assocaited with this. HAving an Excel formula or VB code will do some analysis. Example

Exported Med ID Data Source 1Exported Med ID Data Source 1 Number of Times Not Availle able Med ID- Matched Result From Col B to Med Id in C

View 9 Replies View Related

Move Macro Result One Column To Right

Mar 4, 2013

I have this macro which ranks in reverse order col AA , I need to get the macro to do this ranking in col U .

The smallest number would be ranked 1 to the highest number ranked last .

All I need is the current result too go into col U and not col T when I run macro .

Please ignore the Value error in col T they don't matter at all .

Sheet1  STUVWXYZAA1Fsz   PtsFwinFplNo.Swin213#VALUE!   
SCRSCR1SCR3135   7.52.427.2413#VALUE!   
SCRSCR3SCR5132   4.51.6545.36131   5.51.855.17134   5.51.865.88133   5.51.875.491310   266.5819.610138   
184.5916.911136   164.5101312137   102.81114.21313#VALUE!   SCRSCR12SCR14139   185.51317.8

[Code] ..........

View 2 Replies View Related

Getting Most Common Value Of Column That Is Result Of Filter

Nov 1, 2013

I'm applying a filter in a sheet that's something like this, after applying the filter it looks like this (Example Item 999)

Item
Inv. Qty
Avi. Qty
Flag
BOX

999
12
9
N
X1

[code]...

I was trying to get the "Flag" Column value, (inside the filter and it crashed)

Code:
With InventorySheet
.AutoFilterMode = False
LRowOnQ = .Cells(Rows.Count, "Q").End(xlUp).Row
.Range("B1").AutoFilter Field:=2, Criteria1:=Project
.Range("D1").AutoFilter Field:=4, Criteria1:=ContractNumber
.Range("N1").AutoFilter Field:=14, Criteria1:=Code
.Range("Q1").AutoFilter Field:=17, Criteria1:=">0"
Set rangeFilteredInventory = .Range("Q1:Q" & LRowOnQ)
ControlFlag = .Range("L2").Value
End With

After the filter, it always take the same value.

Code:
With InventorySheet
.AutoFilterMode = False
LRowOnQ = .Cells(Rows.Count, "Q").End(xlUp).Row
.Range("B1").AutoFilter Field:=2, Criteria1:=Project
.Range("D1").AutoFilter Field:=4, Criteria1:=ContractNumber
.Range("N1").AutoFilter Field:=14, Criteria1:=Code
.Range("Q1").AutoFilter Field:=17, Criteria1:=">0"
Set rangeFilteredInventory = .Range("Q1:Q" & LRowOnQ)
End With
ControlFlag = InventorySheet.Range("L2").Value

Is there any way to take the most common letter of the result range?

I'm aware there's a average option in subtotal, but I think it's just for numbers.

Code:

With InventorySheet
.AutoFilterMode = False
LRowOnQ = .Cells(Rows.Count, "Q").End(xlUp).Row
.Range("B1").AutoFilter Field:=2, Criteria1:=Project
.Range("D1").AutoFilter Field:=4, Criteria1:=ContractNumber
.Range("N1").AutoFilter Field:=14, Criteria1:=Code
.Range("Q1").AutoFilter Field:=17, Criteria1:=">0"

[code]...

And it doesn't even do the loop.

View 1 Replies View Related

Compare Data Of Two Columns And Want Result In One Column

Apr 3, 2014

I have one column which contains suppose first names & i have other two column which contains first name & last name in same sheet but like they may be having in g & h column.

so i want to exact last name of user form that column(g & h) to my first name column(a).

View 1 Replies View Related

Formula To Get Desire Result From Values Of Two Column?

Feb 25, 2014

I have set of column data A & B In those A contains Serial No & B contains Ticket No...

I am looking for formula to solve the function by those conditions... almost get done by countifs functions.

1.If Serial & Ticket No Only Once result should be "FIRST TIME LABOUR ONLY"
2.If Repeat Twice For The First Serial No And Ticket "Labour Only", For The Second Serial No And Ticket "Labour & Parts"
3.If Serial No Twice But Ticekt No is different for both serial no Result Should be "PART USED 1 OF 2"
4.More Than 2 Times Serial & Ticket No Repeats" Result Should Be "CCI"

View 5 Replies View Related

Find Column Character Search Result

Jun 9, 2009

I'd like to search for text and get the column character where the cell with the found text. The combination the two 'demands'/formulae into one are giving me problems. And the fact that the column character can exist out of two characters I cannot solve.

I can get the column number with HLookup right? and it gives me the column number, not the character. I can solve this partially (and ugly even more) with =Char(((Hlookup etc)+64 (letter before A))).

View 5 Replies View Related

Filter Only Decimal Numbers - Result In Same Column

Apr 3, 2012

I have few numbers in Column "A". Few are normal figures & few are decimal numbers, like this:

20
5
5.63
4.5
200
53.263
125.5

Now I want to filter only the decimal numbers, so that after filter the result will show like this:

5.63
4.5
53.263
125.5

But I don't want to use any other column for doing so. I can do it using MOD in other column but I want the result in the same column.

View 7 Replies View Related

Match A Call To Column And Give Result

Sep 18, 2006

Attached is a spreadsheet that contains a list of Football teams (F) with corrasponding numbers next to them (E). In column A is a list of footballers and column B has a corrasponding number. WHat I want to be able to do is type in the footballers names in A and type a number next to them in B, in column C it would read off the corrasponding Team number and populate it with the team name. In the attached example I'll manually list the fist teams in B, i need a formula todo this for me. Probably quite simple.

View 2 Replies View Related

Search Column Add Result Rows To New Sheet

Jun 4, 2008

way I can search a particular column, and when results are found, copy the rows where the results are to a new worksheet? And perhaps reuse the same worksheet (so clear the sheet on every execution)

I have tried auto and advanced filter but its not really working to my liking....

View 6 Replies View Related







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