# Tagged Questions

**0**

votes

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**0**answers

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 ...