Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
15 views

AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting. Ex: For cells, I choose A1-A3. A1 is the percentage value 10%. A2 is the number value 20. ...
0
votes
1answer
11 views

Changing external workbook Links in Excel

I have a report spreadsheet that I use monthly. It uses data from multiple workbooks that are linked to it. To update the report every month, I copy the tab from the last month and update the links. I ...
0
votes
2answers
26 views

Excel COUNTIF range search returning #N/A

I'm using Excel to search multiple days (my ranges) in a timesheet for hours worked (my HLOOKUP reads the value below the dept number) by multiple members of staff for different departments. I've ...
0
votes
0answers
6 views

Grouping and Nesting don't work

I have downloaded the example for grouping and nesting for ExcelWriter 7.6. But on my system the tags %%group, %%endgroup and also the cell &&value(...) will not be substituted by data. All ...
0
votes
2answers
17 views

Excel - formula to calculate average for variable number of rows in table?

I have a table where the value in column B is the average of some preceding values in column A. I want to use a named range "DaysToCount" to vary the number of rows used for the average. I've tried ...
0
votes
1answer
12 views

Keyboard Shortcut to Run Macro in Excel for Mac

Basically the title says it all. In the editor in Excel on Windows, all you have to do to run a macro is press F5. What is the keyboard shortcut to do this on a Mac?
0
votes
1answer
19 views

Make excel assume that I want to open my xlstart file readonly

I have a workbook called Book1.xlsx in my XLSTART folder. Is there a way to tell excel that I want it to always open this file as readonly unless I specify otherwise? There are two reasons I want ...
0
votes
3answers
15 views

Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content. Column"A" in both worksheets have matching values but all other fields are different. Worksheet1 Col"A" colb colc cold ...
1
vote
3answers
24 views

Excel format cell with its value over another cell's value

I have a number in A1 (let's say it is 10). This represents the number of answers in a test. In B1 I have the number of correct answers from the test (let's say this number is 6). In B1 I want to be ...
0
votes
0answers
32 views

How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data. Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...
0
votes
1answer
28 views

Get row number for the row matching multiple criteria in Excel

I have 2 worksheet that work together. Worksheet "Application" has a DATE column, a CODE column (a single digit number), and a VALUE column with a dollar value. Worksheet "Scheduled" also has a ...
1
vote
1answer
21 views

excel link to another sheet in same document without using filename?

This formula does exactly what I want: =HYPERLINK("[!Monitoring Profile Matrix v2 (In Progress).xlsx]Metrics!3:3", "POWR01") However, if I rename the document, I'm assuming all my links will break. ...
0
votes
2answers
26 views

How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet. Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...
2
votes
2answers
738 views

How do I get “yes” or “no” in Excel if the information comes from “true” and “false”?

first of all, I have to point out that I am a German visiting this forum (I couldn't find anything useful on the German websites), so excuse my English if it is bad here and there ;-) Here is my ...
1
vote
1answer
16 views

Excel: Plot order total in map coordinates

I have a set of data that looks like this: -X--Y----Amount- AE 24 $178,00 Y 27 $162,00 AD 34 $680,00 AK 35 $178,00 Y 25 $29,00 U 23 $178,00 X 38 $193,00 AC 30 $226,00 AK ...
-1
votes
1answer
25 views

Excel: Use array to sum product by row

Is there a way to use SUMPRODUCT or use an array formula with arrays of differing sizes? Currently I have a list of ~1500 products in column A and columns B-I contain their respective component ...
0
votes
1answer
19 views

Finding interest rate automatically

would really appreciate the help rendered. I'm told to come up with an excel document that disable the usage of any add ons and macro. I need to find interest rate where my inputs correspond to a ...
0
votes
1answer
18 views

How to define a specific row height for Word table row similarly 'Row Height' feature in Excel?

In Excel we have 'Row Height' where we can enter a number to define the heihgt of a row. I want to do the same in Word but there is no such command when right clicking on the row. And currently we ...
0
votes
0answers
9 views

Infopath form restricted to edit from template

I have a .xml form, When I open it, I can't edit it and as you see in the picture, It say that editing restricted from the template : When I open final form.xsn , I can't find anything under ...
0
votes
2answers
32 views

How can I trigger an Excel macro by hovering a mouse over a cell?

I have not been able to figure out how to run an Excel macro by moving my mouse over one or more cells in my spreadsheet.
0
votes
0answers
6 views

Is there a way to open each dragged text file in a new sheet in same excel workbook?

I drag text files into an Excel workbook. Can I drag multiple text files into same workbook and make it open each of them in a separate sheet?
0
votes
2answers
43 views

Adjust decimal separator in imported charts

I am about to write an English document with the German versions of MS Word and Excel. I use Excel to create a chart which I import into the Word document (by Copy & Paste). I can tell Excel to ...
0
votes
0answers
15 views

Excel 2013 single cell is changing to last typed value

I am working on a sheet with names, addresses and dates. An error has occured to where a single cell C342 is now changing to whatever I type in ANY other cell. So if I type in A333, C342 changes to ...
1
vote
2answers
28 views

Formatting date in excel for csv upload

I am looking to upload a csv file to googl apps. I am outputing my date from sql as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy. Is there a way to ...
0
votes
1answer
18 views

One dimensional charts in excel

I have 5 measurements (series) of six values going from 1 to 6. So, Series 1: 1.3;2.5;3.2;3.3;3.9;5 Series 2: 1.1;2.8;3.1;4.4;4.9;5.1 ... I would like to create a scatter chart where Y-axis would ...
-1
votes
2answers
41 views

Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item. Here is the data table: Date Item Quantity Operator 01/01/2014 Item1 3 John 01/01/2014 Item2 5 ...
0
votes
0answers
13 views

Pivot Table Does Not Refresh Source

Typically, when selecting a data source for a pivot table in Excel 2013, it is possible to refresh the table by selecting "refresh table" or "refresh all". This triggers an update in the Pivot Table ...
0
votes
2answers
26 views

Forcing Date format

I have the the following date format 02/02/02 and I need this format to save to a csv file to be uploaded. How do I program excel to not force the date back to 02/02/2002 ? Thanks in advance.
0
votes
1answer
22 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
3answers
83 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in ...
0
votes
1answer
23 views

Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel. Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...
0
votes
1answer
21 views

How to move the y axis to the left in excel , scatter plot with x-axis log scale?

I have my scatter plot with x-axis log scale like below: I want the position of y-axis moved to the left. How can I do this?
0
votes
1answer
40 views

Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops. I am trying to figure out VB code that would help in achieving the flliwing: ...
1
vote
1answer
24 views

Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...
-1
votes
1answer
23 views

How can I populate other columns after user selects choice in drop-down?

I have a spreadsheet that is essentially going to be a form for our user to print out and hand to the necessary individuals. What the user needs to be able to do is select a customer number from a ...
0
votes
0answers
18 views

Is it possible to insert multiple objects at once in Excel 2007?

My co-worker keeps a spreadsheet of candidate data, which includes the resume of each candidate inserted as an object. How can we insert multiple objects (resumes) at one time, instead of going ...
-2
votes
1answer
22 views

How to assign a unique number per group of entries in a column?

I have a list of part numbers in Column A and a location in Column S. I need to assign a value of 1 for all part numbers that are the same (A3-A16), then change to a value of 2 when the part number ...
1
vote
3answers
45 views

IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx We have Excel 2007 (German) and vista ultimate. I am trying Excel by building a roster but have run into a problem with the following formula. ...
0
votes
1answer
28 views

Excel shows different files in same window

In Firefox, I downloaded an Excel spreadsheet and it displayed a dialog box asking what to do with it, so I selected "Open in Excel". Then I downloaded another Excel spreadsheet and opened that one ...
0
votes
0answers
19 views

Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data: -0.0892 8 -0.0711 16 -0.0529 19 -0.0348 13 -0.0166 5 0.0015 12 0.0197 5 0.0378 5 0.0560 3 0.0741 4 0.0923 5 0.1104 1 I would like to add a ...
0
votes
2answers
42 views

SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for. On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...
-2
votes
1answer
40 views

Randomize Huge List - Windows 7

i've been searching for a solution for this but i couldn't find it anywhere. I have a large list, more than 2 million entries. I need to randomize it. I can randomize lists in excel but excel ...
1
vote
1answer
14 views

Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...
0
votes
1answer
15 views

I want to create a format in Excel to trigger a colour code?

Currently I have a drop down list on certain cells, connected to a list of statuses. 'Complete' which marks as green, 'Pending' which marks as orange, 'Outstanding' which marks as Red. I want each ...
0
votes
1answer
22 views

Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...
0
votes
1answer
26 views

Cell in a cell excel 2013

Is it possible to insert a cell in a cell? I need to divide a cell in half horizontally. I don't want to have to insert another row as I would like it to be horizontal. Can this be done?
0
votes
3answers
45 views

Average Difference and Direction Between Values in Excel with Blanks

I have a sheet that looks something like this: Sheet 1 1 2 3 4 5 6 7 8 9 10 11 1 6 2 3 5 3 ...
0
votes
1answer
21 views

Named ranges changing randomly in Excel 2010

I'm trying to create some named ranges in Excel that extend using the offset function based on the number of non-empty cells in a column, with the general formula: ...
1
vote
0answers
23 views

What can slow down Excel in copying worksheets, but doesn't slow down general responsiveness?

I've got a fairly complex workbook that I'm building, and it looks like it's going to need a number of the sheets copied 10-20 times over - where each copy operation takes ~45s at the moment (over ...
0
votes
0answers
15 views

Open Excel on last modified page

I have a spreadsheet with 13 pages. Theoretically, when I open it, then modify it, it SHOULD next open on the page I most recently modified. It does not. It's opening on a page that hasn't been ...