I have a formula in a workbook that keeps giving me #DIV/0! no matter what I do. I am trying to total up a column of numbers. If I enter into B28 the following formula : =SUM(D4*E4)+(D5*E5)+(D6*E6)+(D7*E7)+(D8*E8)+(D9*E9)+(D10*E10)+(D11*E11)+(D12*E12)+(D13*E13)+(D14*E14 )+(D15*E15)+(D16*E16)+(D17*E17)+(D18*E18)+(D19*E19)+(D20*E20)+(D21*E21)+(D22*E22)+(D23*E23)+(D24*E24). it does not give me the #DIV/0! but the result is incorrect.
what I need is a formula that totals rows 4 through 24 but the formula for each row individually would be =(d4/b4*e4) but I am trying to avoid having to add multiple extra columns (& clutter) for each item in each row that I need to calculate. I have attached the workbook so that you can see what I am trying to do.
So I created a custom Add-In, but the add-in isn't removing itself when I uninstall it or when I close the program (this creates an error in saving files, so all files are getting corrupted)
This is all the code I have running the menu bar and I can't figure out the proper closing code
I am trying to organize some meteorological data for a project and I ran into a wall, basically I have 3 columns in one there is the date, in one the hour and in the third one the temperature the issue is that in the hour section i have the hour 12:00 that repeats its self , and this goes for the hole year , pretty much every day i have the hour 12:00 that repeats twice , so select for every Monday , Tuesday etc only certain hours.
I have list of data references about 60000 of them but some are duplicated. I have used advanced filted then unique records only. So now i have just the unique records showing now. How do i copy the accounts that is just unique into a new worksheet? I tried copying it but its copying everything. I even tried using paste value but still copying everything?
I have some cells full of user entered information that has returns in it, so that it's multiple lines long. What's the best way to remove returns from a string?
It seems like I am asking a question at least once a day. I searched the net and forums and could not find an answer to this question. Thanks to everyone for the help I am making a lot of progress because all of you. Basically, I have a read-only workbook which the user gets a prompt to save as a new workbook for editing purposes. I have a autorun macro so now when the user opens their workbook, it contains my autorun macro. I do not want this. Is there a way to remove modules so that the users copy has no macro information?
i have columns of prices in 2 decimal format that I'd like to manipulate, some prices are whole dollars(no cents & no decimals ) and most are dollars and cents in decimal format-- but to do it successfully, i need the decimal removed. I looked at the "format" function but it doesn't seem to allow for that.
is there any way I can have these prices converted to "cent" format( ie removing the decimal, where applicable), showing them not as "dollars & fractions" but as "cents" i'm sure that would solve the problem for me last time I did it by hand and vowed there had to be an easier way!
I was wondering if anyone had a formula or Macro suggestion to remove rows with no information. I made a pivot table that feeds to another sheet in order to make it more user friendly. The only thing is when there is no information I have formula to returns a zero. I would rather the row be hidden.
I have a spreadsheet which contains 2 columns of data, most of which are duplicates.
I'm looking for a macro which will check all of colum A (A2:A138)
against
Column B (B2:B163)
I would like the macro to remove duplicate entries (from column A) in column B so that all that is left in column B are entries which don't match any in column A
Private Sub CommandButton1_Click() Dim row, col row = ActiveSheet.UsedRange.Rows.Count col = ActiveSheet.UsedRange.Columns.Count For i = 1 To row For j = 1 To col Cells(i, j).celarContetents Next Next End Sub
but next time the cell count is showing previous rows value?
I have a set of data in a column and I'm trying to add them but can't because of the way it was imported. Each cell has a number with a space at the end. How do I remove that space without having to manually go in there and deleting via F2 > backspace, F2 > backspace, and so on.
I am trying to remove ’ê characters from my excel sheet, as they are preventing me from using the text to columns function correctly. I have attached an example extract of data, could someone let me know how I can remove these, as the find and replace wizard in excel doesn't allow me to do this?
Currently I've been able to remove the prefixes and suffixes using the replace option as those were consistent across the data set, I'm now left with a series of numbers that look like this:
In most cases I need to remove the information after the last period. Some of the data has a space at the end, instead of a period and then some have no space or period but have the letter that needs to be dropped. I'm using xl 2011 for MAC.
I have tried to set one formula which will given the the Numbers of the Vehicle. However as there are other numbers also which makes it difficult to do so.
I have a problem, I have a workbook that is used for importing products on to my website but for the description field it keeps adding the double quotes to the text. this text is HTML code. when I import the products to my website, these quotes show up at the beginning and end of the description. You can't see the quotes in excel but if you copy and paste the cells data in to a text editor you will see the quotes.
My question is how can I remove these? I have removed them in the text editor but as soon as the data goes back in to excel the quotes are automatically inserted again...
I have a column of data which has numbers and units (small example below). I need to remove the text (units) and at the same time multiply the number by a value which is based on what the text is:
The equation is basically: 10^[A/20]+10^[B/20]+10^[C/20]. Now imagine that there is no input value for C. I need to make it so that it won't add the bit I've highlighted in green.
I would like to combine 3 string together but I would like to remove the duplicate found in any of the string. I attached an example with the desired result. I know =A1&""A2&""&A3 can combine the string, as I wan a space between each string. anyone can further edit my formula to remove the duplicate ...
I need to do a lookup on these cells but for some reason they all appear to have some kind of space characters in each cell which you can see if you double click on them. I have tried trims, text to columns, find replaces and none of these seem to work
I have a huge list of these numbers / codes and they all have the weird space kind of characters at the end
Can anyone give me a solution on how to remove them so my lookup will work?
I need your guys expertise in the following formula. I'm applying the following to a large range of data that varies in lenght,however all of the data has a 1Y or 2Y at the end of it. I need to remove it from the data into a new column. Currently I'm using =trim(mid(A2,1,30) how can I change my formula to obtain my results?
