The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
10 views

How to make a Custom List with sheet cross reference?

At the end of the month i get a excel file with a variable number of sheets. Every sheet has a value in the same cell: A1 I want to create a new sheet and display all the values of A1 on every sheet ...
0
votes
0answers
12 views

Formulas speed when opening/save the file

I have a file with many formulas, when i open the file or save it takes a lot of time before of the formulas, is thee a way to avoid that?
1
vote
1answer
15 views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
-2
votes
1answer
35 views

try to fix my Excel formula

I have similar tables in sheet1 and sheet2. I want rows, with new names, to be added automatically to table in sheet2 if I manually add them to sheet1. Example: If I add a row with the name "Jane" in ...
0
votes
1answer
18 views

Excel Dates Transformation

How do I change the dates in Excel for the below scenario: Existing dates: 2/2/2014 3/12/2014 1/1/2015 2/1/2015 Target converted dates: 3/31/2016 3/31/2016 1/1/2016 2/1/2016 I want all the dates ...
-3
votes
3answers
31 views

How do I get a cell on Sheet 2 to reference a cell on Sheet 1? [on hold]

I have an Employee database in Excel 10 with several sheets. I want to change one column in sheet 1 based on another column in sheet 2. sheet 1 Sheet 2 Column A, Column B ...
-1
votes
0answers
20 views

Modify Excel data connection without disconnecting the connection file

When I link a data connection file to a workbook, and then edit the SQL query (to include dynamic parameters), Excel says: The connection in this workbook will no longer be identical to the ...
0
votes
0answers
19 views

How to insert a row into an Excel sheet1 and automatically insert the row into sheet2 [duplicate]

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

Automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1

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

Text to columns in Excel - break into columns selectively

I'm trying to separate a single cell into columns but I just need the last 3 values (separated by "space") to be in the separated cells. I have this (in one single column): Column A ...
0
votes
1answer
29 views

How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä? [duplicate]

How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä? The file is tab delimited. Windows 7, Excel 2010 Edited ten minutes later. I drag and drop one .txt file and it works ...
0
votes
0answers
7 views

i want to copy paste a mobile number from excel to true caller search bar [on hold]

hi someone could please help me out with a macro in excel : I want to copy paste a mobile number from cell in excel to web page of truecaller's "search" area http://www.truecaller.com/in/&cell ...
0
votes
1answer
17 views

Highlight Data Points in a line graph on excel 2010 or 2013

I have a line chart (two series of data) and I need to highlight a specific point in the data. Is it similar to the bar chart where you can just change the color or is there something different? ...
2
votes
0answers
21 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
1
vote
2answers
27 views

Excel '10 Formula to find & sum a row based on the intersection of 2 data points. (ie. Name(row), Month(column)

I need an Excel 2010 array formula that will take 2 given data points, say a "Name" (row) and "Month" (column), and return the sum of a row based upon the intersection of these two points within a ...
0
votes
2answers
25 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
16 views

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

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
1answer
32 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
29 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
20 views

What formula can I use to find the MAX in the next 12 rows? [on hold]

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

How to split many excel by equal values [closed]

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
14 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
21 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
12 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
21 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
28 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
24 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
25 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
40 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 [closed]

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 ...
0
votes
0answers
23 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
23 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 ...
0
votes
1answer
35 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
39 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 ...
1
vote
0answers
49 views

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 ...
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
22 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
47 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
66 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
27 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
43 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 ...