I have the following table in sheet-1 (master table) from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main ...

I have the following table in sheet-1 from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1. ...

How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file?
I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, ...

I'm trying to figure out how to calculate percentages of values that are downloaded through a data connection in an Excel pivot table. The percentages are targets of values that are downloaded in the ...

I have a two worksheets, one in which I have a list of tasks as well as several other columns listing the status of the task and one column listing if the task is imortant or not. In the other sheet, ...

I have two columns
Key and Value
(standard map)
There are duplicated keys. It is trivial to delete the duplicated keys (namely the delete duplicates button). But that would delete some useful data in ...

Copy and paste the folder file path into a web browser (Chrome). Then CTRL + A the browser page into an Excel document. This will hyperlink all the names. Then it's just a matter of sorting. There are ...

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process.
Here is the VBA ...

I'd like to use Excel 2010 to show on the x-axis when discrete events occurred and on the y-axis the magnitude of those individual spurious events. My goal is to try to visually analyse when different ...

I am trying to calculate individuals' variances on multiple measures, however, if they skip a question it is coded as -99. I would like my formula to calculate the variance for these measures while ...

probably not relevant. my laptop is win8.1, lenovo yoga11s. the excel version is excel 2010
I am doing this chem lab report and I need to do some simple arithmetic calculation. I need to subtract the ...

I do a monthly budget type of thing and have some hobby shares around $3000 value. I have managed to link my Yahoo share page to my budget excel sheet. I put a monthly total of bank accounts shares ...

I want a macro that will fetch data from Series B and Automatically paste it according to the serial of Serial A. ASeries B and Series A data are same but Series B is not ordered. So i'm looking for ...

I am creating a worksheet that compares two sets of data pulled on different dates. The column that everything pulls off of is created by an array formula comprised of combined unique values from the ...

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...

I have a if statement in a cell that looks for the value in two different cells depending on which one is >0. Both target cells have a formula that selects a value based upon the value of the cell as ...

I have several Excel workbooks which were originally created in a 2007 version.
They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content.
...

I have a number of cells on a worksheet that reference another worksheet. Pretty straight forward except I have to type the name of each worksheet in each formula which is becoming monotonous. What I ...