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
0answers
5 views

Scanning and adding the values

I need to scan hundreds of pages with numbers written on them in the bottom right corner. Post scan - I need a OCR software to recognize the number written at the bottom right corner of each page and ...
0
votes
2answers
21 views

Excel TRUE/FALSE IF statements

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
1answer
10 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
0answers
20 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
0answers
9 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
0answers
16 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
0answers
10 views

Decoupling Pivot Table Groupings

Is there an option anywhere in Excel that I'm missing that allows you to decouple two pivot tables? The default option is to change groupings of a particular variable to be the same throughout all ...
0
votes
0answers
17 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
1answer
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
2answers
36 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
0answers
14 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
1answer
15 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
2answers
26 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
1answer
15 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
0answers
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
0answers
6 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
0answers
16 views

Excel automatically joining two or more columns into one

I am having a very weird problem in Excel 2013. For example, lets say i have a worksheet with these values in 3 : TEST | Col | newCol TEST2 | Col | newCol TEST3 | Col | newCol When i copy it and ...
0
votes
0answers
3 views

Google Sheets Suffix To Column Cells [migrated]

I'm editing a spreadsheet of product data that has a category column. I'd like to create a new "Left Handed" as well as "Right Handed" category in addition to each products current categories. I've ...
0
votes
1answer
6 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
1answer
15 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
1answer
17 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
2answers
29 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
0answers
35 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
1answer
13 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
24 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
15 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
11 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
14 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
31 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
26 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
25 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
728 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
15 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
21 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
17 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
7 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
26 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
38 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
26 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
17 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
34 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
10 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 ...