I have copy 65'000 formula text cells from a software and paste it to excel. But, the formula in cell is not activated. In order to activate the cell formula, I have to click on each individu cell and press enter to active it. But i got
65'000 rows of the similar cells. So, what is the quick way to all the text formula at the same time.
My goal is to sum up the total sales and total forecasted sales of each cost center. I compiled a formula that is supposed to do this just as I want it to. Simple enough. However, for some odd reason the formula returns either the totals of ALL cost centers or just a zero instead of the correct result. The weird part is that when I check the formula by pressing the "insert formula" button it suggests that the formula actually should produce the desired result.
View 5 Replies View RelatedI have a problem in copy formulas form one cell to another, my formulas are writen in one workbook in this way... '=Dog+Cat.
The problem is that I did a looking table code (vlookup) and when it shows the formula I have #¿Name?.
I would like to knw if there is a way to fix this using the vlookup or I'll be obligated to use special Copypaste
I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.
View 2 Replies View RelatedI need to create forumulas for fed,state,medicare,and fica taxes. It has to be an absolute forumula where i use percents. One would be i have my gross pay in column e5, my fed taxes which is 18% in f5, but the 18% is above that in F4.
View 3 Replies View RelatedI have a range that has formulas that are based on other fcells outside the range.
What I want to do is, if the cell has a value to remove the formula and paste the results. If the filed is blank (no results from the formula) to leave the formula in place.
There could be a marco to run when this process is needed.
example attached
with a macro. I am looking to copy row 2 to the last row and past the copied rows directly below the copied contents.
View 9 Replies View RelatedHow can it be changed to show the results instead of in Column A, in say range E10?
Code:
Option Explicit
Sub InsertRows()
' hiker95, 09/28/2013
[Code].....
I believe the problem lies somewhere with the Resize bit of the code, which I do not know how to change to display the results in Cell E10 and down.
how to take the result of a formula calculated in one cell and show the results in an other cell
View 4 Replies View RelatedJust yesterday when I opened my excel file, all the cells that contains formulas does not display the results (leaving the cell blank).
For example the formula for cell A1 is =B5. But after putting a value in cell B5, cell A1 is still blank.
I have a spreadsheet that holds salary information. At the moment it shows against each person the highest salary for a person of the opposite ***. What I would like to do is have another cell that shows the names of all people who have that salary.
E.g. if the highest comparable salary for someone of the opposite *** is 30000 then I would want a list of all the people with that salary.
Is it possible to do a look up that would show all the results that match certain criteria?
In column B I only want to show the results from Column A if the character count equals 3. In Column C I only want to show the results from Column A if the character count is greater than 3
Example:
Column A
ast
john
julie
tyw
nhy
frank
I'm currently working on a model that calculates the costs associated with various phases of a project. I want to allow the user to input the number of weeks that each phase requires as part of the calculations. The result will then be displayed horizontally in chronological order with the values associated with each phase underneath ex:
phase 1 phase 1 phase 1 phase 2 phase 2 phase 3 phase 3 phase 3
Through multiple lookups I've been able to get the data into this format:
phase 1 phase 1 phase 1
phase 2 phase 2
phase 3 phase 3 phase 3
What can I do to merge these series into one series that is in the order I desire (each phase will vary in length based on the user's input)?
I have three search boxes in XL , two are search from and to dates and the other is search be ref.
I can currently search by dates and ref but would like to show all records in the specified dates if the ref field is left blank.
I am using the query writer and referencing back to cells in XL. I don't use the wizard or SQL. I have tried many options and think I should be using a OR statement with a wildcard but can't seem to get the result, does the wildcard just show the blank cells in the actual data?
I am trying to determine the best way to graphically show the results of a time/work study. Basically i have a list of tasks and each list has 2 sets of numbers assigned to it. One for how much time it takes on a scale of 1-3 and a second for how much value is added for the task, again on a scale of 1-3. I want to show some sort of graph/visual that shows the number of tasks as clusters (not name of task) in maybe quadrants. With the time on X axis and value on Y axis. I am envisioning something like a 9 box that would have low/low to high/high. I can only think to create a 9 box in excel and physically put circles(clusters) in each quadrant.
View 2 Replies View RelatedThe results of the formula in cell K36 in the attached spreadsheet returns a value of null. It should be $1,200. Am I blind or have I done something wrong. I just can't see the problem with the formula.
View 6 Replies View RelatedI have a big DB with several rows and columns.
Column B has several card numbers (e.i. 7987654345678)
Column C has a location name (e.i. madrid)
Column L has a date (the date is when the card was used)
What I want to do is identify the cards that appear more then twice on the same date and the same place.
Card Number
Location
Date
123
LOC
18/01/2013
[Code] .........
I would like through a macro or pivot to show me the results of the 2 last rows, because those are the only ones that are exactly the same.
I have excel 2007 running on Windows7
Basically a cell might have a number with 3 decimal places
For Example 90.554, and i will format the cell two 2 decimal places. But when i use those cells which are formated to 2 decimal places in a formula it produces results based of all the decimal places in that cell.
Is there a way for the formula to only calculate the results based off of what is shown in the cell? . This is messing up our accounting area by alot of dollars since we sell many items.
I included an example of what i mean in this excel file which should clear up any confusion.
I'm trying this code but its not showing the formula in cell Z1, what am i doing wrong here ??
View 2 Replies View RelatedIt's been a long time since I have worked with Excell, it use to be the " $ " that made things absolute or relative.
I have this formula:
='1'!C194+C193 on sheet 1 named "1" without the " ". I need to copy it across 31 sheets. I thought that it was the " ! ", without the " ", that makes the address absolute so I took it out and then attemped to copie it to other sheets. The idea was that the formula would then read: ='2'!C194+C193 on sheet 2, and ='3'!C194+C193 on sheet 3 and so on. The formula is in the exact same location on each sheet, C194. But this won't work. I am at this time doing each formula one at a time. I have many workbooks that will use the same style of copy and paste; about 15 workbooks each with 31 sheets.
It would help if someone could explain how to save time. I do know how to use the Ctrl to select different cells and how to use Ctrl+Page UP/Down to change tabs. I just have to get the formula correct.
I have a formula that basically copies a cell into another workbook if 'other' is entered into the column to the right. i,e cell A1 has 'other' B1 has '100', the figure in B1 is placed into another workbook cell. The results are only shown if a month is selected from a drop down on the 1st workbook with the meta data.
What I want to do is to add a command to the formula below so that it will recognise that after the first item is entered it will look for the next data item and not just repeat the first….
{=IF($L$92:$L$580="","",INDEX($L$92:$L$580,MATCH(1,(TEXT($C$92:$C$580,"mmmm yyyy")=TEXT($E$5,"mmmm yyyy"))*($L$92:$L$580<>""),0)))}
In the attached worksheet is an example of what I want (table 2) and what I'm currently getting (table1)…
I am trying to write a macro that will allow me to copy the text of a cell, and then insert text around that previously copied string. I am having a problem adding the copied text into my formula. Here is my code below:
Sub Bid()
'
Selection.Copy
ActiveCell.Value = "inventory levels are " & ActiveCell.PasteSpecial(xlPasteValues) & " and oversold by"
ActiveCell.Offset(1, 0).Select
End Sub
I am looking for a formula that reads down when drug to the right.
I am trying to copy a formula down a row. All I am getting is the exact same answer from the 1st cell instead of the new data.
View 9 Replies View RelatedSuppose I have 100 worksheets in a workbook ( named 1,2 3 ........100) in a collecteve sheet ( I have a coulmn of 100 same formulas refering to the same cell in all the 100 worksheets)
for example :
'1'!$a$1
'2'!$a$1
if I drag the first formula Fill Down With Fill Handle then, the sheet name will be the same all the way down(1) , which is not correct , so I have to go bach and modify them manually , which is very boring and mistakes could easily happen
I am trying to create an "if,then" formula that shows:
if cell E8 is greater than 171, then i'd like cell E9 to show the value of cell in E8.
I have a spreadsheet which imports data from worksheets week 1, 2 etc to a monthly summary.
Is there any way I can show a cell as blank if the return equals 0?
I'm sure the resolution is probably simple but then so am I.
On my spreadsheet i have 4 columns which are in currency format. The 5th column (total) adds the 4 up which currently looks like this - =SUM(BG44:BG45) this shows £0.00 in the 5th column.
What i need is a formula in the 5th column (total) so that when it adds up the 4 previous columns if the sum = £0.00 then the total column should show a blank cell.
in my document column "L" have some formulas,it's like this.
=150*1.5+25*1.5
i need to make that formula to two part.it's like this.
=150*1.5
=25*1.5
that two part need show below that formula cell in two rows.
I am trying to get my cell to match the name of the file. I am aware of the following formula: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)
This does return what I want, but members of my team often have several sheets open within one Excel window. The formula returns the most recently opened file within the window rather than the name of that particular file. This then distorts my results sheet as it ends up with the name of the most recent file opened rather than the person's name (which is what the file is called)
