The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
6 views

Export excel chart to png with certain dimensions

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, ...
0
votes
0answers
12 views

How to add a percentage calculation to raw data in an Excel pivot table

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 ...
0
votes
0answers
28 views

How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet: Roll-No:- 801 Maximum Marks 20 20 20 20 20 20 Sig. of Class ...
0
votes
1answer
19 views

Conditional formatting in Excel according to today's date

I have an Excel file that links to some documents, certificates and such, which are valid for a year. For example, since Feb 20, 2014 until Feb 20, 2015. To the right, I have a column in which are ...
0
votes
1answer
17 views

What formula can I use to find the MAX in the next 12 rows?

I need a formula to find the maximum value of C10:C21 then C22:C33 then C33:C45 then C46:C57 and so on... as you can see it finds the max of the next 12 rows. Here is what I want it to do: ...
-1
votes
0answers
16 views

Modify Excel data connection without disconnecting the connection file

I have several workbooks which connect to the same SQL server data source. I would like to store the details of the data source in a file in a central location, so that if the database is moved to a ...
0
votes
0answers
14 views

Count unique items from Filtered range

I have been trying to solve this one for a while. I have a main Excel list for tickets logged since 2013. The list contains the columns: Ticket number Date Username engineer name I use filters ...
1
vote
1answer
22 views

how to find partial text in excel

I have two columns "A" & "B". Column "A" contains Complete Text (1000 line items) & Column "B" contains partial text (250 line items). How I can find & place all Partial text(Column B) ...
0
votes
1answer
33 views

Count filled cells in row, given from adjacent column not being empty in Excel 2010,

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, ...
-2
votes
0answers
10 views

How to split many excel by equal values [on hold]

How to split the excel into many workbook by equal values. I will don't make any try for this. I want a macro for split excel into many workbooks by equal values
0
votes
1answer
13 views

How to search a range of cells for specific txt, then copy to adjacent cell

I have a range of cells, e.g. g1-g1000 that contains two type of entries: xx.xx or xx.xxCR, where xx.xx are numbers. I want to search the range of cells for xx.xxCR and when a cell is found, copy ...
0
votes
0answers
18 views

Delineate Excel Formula Without Using Wizards

Is there a combination of excel formulas that I could use to do this without using VBA or the import wizard? I know how to insert comma delimited data from a text file and to split a cell into ...
-1
votes
0answers
10 views

Excel - Formatting one cell from a series of cells

I am trying to format one cell (H) from a series of cells (C, D, E, F). For example if column C = "x" then column H = 120 if column D = "x" then column H = 160 if column E = "x" then column H = 200 ...
2
votes
0answers
14 views

Mapping Excel sheet to XML Schema - using a column for multiple attributes

I have data like this in Excel: I want to export XML using XML Maps feature like this instance, based on a schema that cannot be modified: <someRootElement> <Foo Key1="A" ...
1
vote
1answer
18 views

In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...
1
vote
1answer
23 views

How do I use fill color for negative values in spider chart?

Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green. For clarification: The color filling is done manually and if the ...
1
vote
1answer
22 views

Excel: combine strings based on duplicate keys

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 ...
1
vote
0answers
36 views

How to align column values with their matching value in another column?

I have several columns of data that I need to align with a master column. The following is an example of what I hope to achieve, but with a table containing more larger strings and more rows. The ...
-1
votes
0answers
19 views

Schedule Spreadsheet Questions [on hold]

I have recently been promoted to division supervisor at a security company and one of my biggest duties is making up the weekly schedule. The current setup uses Excel. I am very low-level when it ...
-1
votes
0answers
20 views

How can I activate this hyperlink? [on hold]

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 ...
0
votes
0answers
21 views

Error when running a VBA in Excel

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 ...
0
votes
1answer
15 views

How to graph values versus time axis? [duplicate]

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 ...
1
vote
2answers
20 views

How do I Calculate Variance with Missing Values coded as -99?

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 ...
-1
votes
1answer
50 views

Excel 2010 display two dates in one cell which sum invoices of that period [closed]

MONTHLY INCOME AND EXPENSES INCOME gen-15 feb-15 mar-15 Pension €1.571,97 € 1.571,97 € 1.571,97 Previous Month €1.143,62 ...
0
votes
1answer
30 views

How do i do a “tweaked” VLOOKUP?

So here is the problem: I have 3 lists (adjacent columns) in a spreadsheet. The 1st list contains the values I am searching for The 2nd list contains the first half of table array which I am ...
0
votes
1answer
36 views

Excel formula that returns row if value is found in a column

I have a list of DNS entries that I need to sort to get the good records. In sheet1, I have a dump of the raw data, in column 1 is a zone ID which is a number. In sheet2, I have a column made up ...
0
votes
0answers
34 views
+50

How to change Control-Y behavior in Excel-VBA's IDE

Excel VBA's IDE register's a Control-y as "cut this line of code". By contrast, redo-ing is accomplished by Alt-e, R. Is there any way to change this behavior and make Control-y be the much more ...
-1
votes
1answer
20 views

Compile a Separate excel files to a single file [closed]

I have 10 separate sheets/files of employees with information of leave plan for the year(Jan to Dec). How can I compile all the detailed information with a single sheet/file in excel.? An early ...
0
votes
0answers
14 views

Adding attachment to cell in excel

How can I insert an attachment (Word or PDF) in a cell in Excel? Meaning that if I refer to the cell I will refer to the attachment itself. If i insert an objective and i try to link to it i got ...
0
votes
1answer
22 views

Unable to do an arithmetic calculation in MS Excel

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 ...
0
votes
0answers
14 views

How do I keep a value the same in a cell

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 ...
0
votes
0answers
34 views

copy and paste according to a order in a column

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 ...
0
votes
1answer
21 views

How to make a custom selection on excel?

Is it possible to make a custom selection on a spreadsheet and in particular on excel ? If yes, how to do it ? (for example, I would like to select one cell on 3 among a column or select only the ...
2
votes
1answer
45 views

Why is my formula pulling the result CELL NAME and not the value of that cell?

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 ...
1
vote
2answers
56 views

Need an Excel Macro to sum a variable length range

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 ...
0
votes
1answer
24 views

Microsoft Excel Query - Formatting Columns

I have got an excel sheet data that looks like this: Order Id Rate Item Quantity XXX 4 Ball 100 XXX 4 Hockey 500 XXX 4 Hockey 500 AAA ...
1
vote
1answer
41 views

Is it possible to hide #VALUE! in a cell?

In A1, I input 1,2,3,4 and so on. B1 remains blank because this is where I will enter a number (qty). C1's content is: =IF(ISNA(VLOOKUP(A1,'Item ID'!$A$4:$E$11166,3,FALSE)),"",(VLOOKUP(A1,'Item ...
0
votes
1answer
23 views

If statement in excel 2007

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 ...
0
votes
1answer
18 views

Subtarcting from total in one cell, based on data validation on another cell in Excel 2010

I have 5 columns from A1 to E1, labelled as Name, date, amount owed, status, total owed. Column D is data validated as Paid in full, Installment, Pending. What I would like to do is when the data ...
0
votes
0answers
7 views

auto reference cells in worksheets built per month; worksheet selected based on the current date

I want to have a dynamic master list of clients that are being seened. The names of the clients change as they come and go. I have a standard list of names with a date when they came in. It is 4 ...
0
votes
0answers
59 views

Excel 2010 shared workbook - image buttons disabled

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. ...
2
votes
0answers
18 views

What function (or functions) can I use to pass worksheet title to a reference?

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 ...
0
votes
1answer
37 views

Excel 2010 workbook startup error

I have an Excel workbook that causes an error when it is started on a particular PC. No other workbooks give the same error on this PC, and the workbook itself causes no problems on any other PC. The ...
0
votes
0answers
27 views

How to separate/filter out number with 3 decimal places into another column?

Please help, currently i'm working on a massive number of data (up to 50 000++). i need to separate or filter out the numbers which have only 3 decimal places into a new column (as bolted in the ...
-1
votes
1answer
30 views

Excel Macro Radiobuttons dependent on cell value

I have a cell A1 which is filled with a dollar value eg. 20000 based on a vlookup. Depending on the value which is found I want 1 of 4 radiobuttons to be selected. 0-40K 40-150K 150-300K >300K ...
0
votes
2answers
52 views

Referencing cell only by column name in Excel 2010 VBA

In Excel 2010, I need to go through a data table row by row and manipulate the data in VBA. My original function reads like this: Private Function GetValue(ByVal myRange As Excel.Range, ByVal strCol ...
-1
votes
1answer
49 views

counting if certain things match

I have a set of data that looks like this: Period Address Name City Carrier Move ID P1/2014 WAL-MART CANADA INC. MISSISSAUGA CMV0066539 P1/2014 ...
0
votes
1answer
15 views

Excel: Using the TEXT function for spreadsheets used by users with different regional settings

I am using the TEXT function like =TEXT(B1, "ddd") where B1 is formated as date to display the weekday. This works fine on an english regional system. On a machine with a german regional setting the ...
0
votes
1answer
38 views

How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...
0
votes
1answer
18 views

excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated. I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...