**1**

vote

**2**answers

28 views

### Excel TRUE/FALSE IF formula

I have a "Pass" column (A) and a "Fail" column (B) in one worksheet. I have a column in another worksheet where I need the following to happen:
If A is true and B is false, return "Pass"
If B is ...

**0**

votes

**1**answer

18 views

### Running a set of data through multiple calculations and outputting the results back on the data sheet

Using Microsoft Excel 2013.
I am creating a calculation sheet for quickly evaluating the metrics of rental properties. I have a sheet called CALCULATIONS with several calculations, and several ...

**0**

votes

**0**answers

25 views

### Can't change column width in Excel

Trying to drag column to change width...as I've done for 30 years. Suddenly, no more dragging. Instead, a pop-up menu where I'm given the option to manually set the width (but can't, because ...

**0**

votes

**0**answers

10 views

### Saving Excel to fixed Width format - extra tabs

I have a VBA macro that takes a spreadhsheet and turns it into a fixedwidth format in another sheet using the first column only. When I save it, it always seems to have extra tabs in the text file at ...

**0**

votes

**0**answers

23 views

### excel - ask for input to be used as new cell values

I use excel 2007 and I want to create the following function:
At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...

**0**

votes

**0**answers

30 views

### how to perform operations between sheets in excel

My question is very easy and I'm sure there is already an answer somewhere but I don't know the correct keywords when searching for them.
So here is the question:
In column C of sheet2 I want to ...

**0**

votes

**1**answer

15 views

### How to get a cell to display a value from one column when the values of another column go above a certain number

I am doing a breakeven analysis and want to know what formula i can type into excel so that once my income column reaches my breakeven point it shows what date that breakeven point was hit. The dates ...

**0**

votes

**2**answers

42 views

### Excel auto fill repeating the same number

I'm taking the difference of some figures and having trouble amending the figures to reflect what the formula is doing (screenshot below). The autofill function is repeating the same number for the ...

**1**

vote

**0**answers

26 views

### Can I modify Excel Online share URLs to open to a specific worksheet?

When I generate a share URL in Excel Online, it takes the following form:
https://onedrive.live.com/view.aspx?
resid=<DOCUMENT ID>&
ithint=file%2cxlsx&
app=Excel&
...

**0**

votes

**1**answer

19 views

### Financial Quarters from date

I have looked around for other solutions to this issue using the =ROUNDUP(MONTH(A1)/3,0) code.
However I am not using the standard dates for Quarters
Q1 - 02-Feb/03-may
Q2 - 04-May/02-Aug
Q3 - ...

**2**

votes

**2**answers

35 views

### Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size.
My idea was to write a powershell script, since I ...

**1**

vote

**1**answer

17 views

### Sorting and removing duplicates

I have the following table:
Column 1 | Column 2 | Column 3
1 | A | 70
2 | A | 32
3 | A | 4
4 | B | 44
5 | B ...

**0**

votes

**0**answers

17 views

### How to build a radar graph? [duplicate]

Does anyone know how to build a graph like this? Preferably in excel or using a simple online tool? There is similar on this web-site, but not exact. I need to have 4 sections, each containing 5-6 ...

**0**

votes

**0**answers

10 views

### Retain original Hyperlink format in Excel (from a hyperlink formula)

I extracted some data online. I wanted to format the hyperlinks as the original hyperlink format when you copy an anchored text online to sheet.
The content of the cells formula is shown as: ...

**0**

votes

**1**answer

14 views

### Open .csv file with template from XLSTART

I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...

**0**

votes

**1**answer

17 views

### Excel: INDEX and array on another sheet

My raw data is a list of students and their grades on Sheet 1.
6th Bobby
6th Carl
7th Tommy
8th Bobby
I want Sheet 2 to give me a list of students based on the grade I input into cell A1.
example: ...

**0**

votes

**1**answer

19 views

### Calculate Break Point Weight

I have a table like so:
Miles Weight Rate
50 1710 54
50 3417 44
50 7253 38
50 12025 36
50 16052 35
100 1716 55
100 3429 45
100 7269 39
100 12027 37
100 16055 36
Where ...

**0**

votes

**2**answers

57 views

### Conditional Matching Based on Datetime

I have a set of names and datetimes on two sheets. One sheet we'll call LargerSheet and the other we'll call Sheet1. On LargerSheet each name has multiple datetimes associated with it. On Sheet1 ...

**0**

votes

**0**answers

44 views

### Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
...

**0**

votes

**1**answer

18 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

12 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

32 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

7 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

27 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

14 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

24 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

**4**answers

28 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

25 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

35 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

35 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

22 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

28 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

772 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

19 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

40 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

21 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

20 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

38 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

8 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

48 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

37 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

24 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

54 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

14 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

23 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

108 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

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