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)

-2
votes
0answers
17 views

Need advice on Excel project! How do I embed an image and what is a “marker”?

I'm building a spreadsheet for certain historical sites, collecting data on it, and etc. This is what I need to do next. "Use Google map to locate the sites. Please take a screen shot of the map ...
0
votes
1answer
9 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
0
votes
1answer
9 views

Excel adding rows based on if they are a number

I'm trying to add rows in a column based on whether or not they are a number. Some rows are numbers and some are not. I have something like the following. But it's not right: ...
0
votes
1answer
12 views

how to get cell number as a result of a function

i need to get № of a cell that contains the result of MAX(J4:J24) and write a word from the same row instead of the actual max number the word can be written i guess via =INDIRECT("A"&formula ...
-1
votes
1answer
16 views

Get differences between two Excel 2007 rows, showing relative changes in second column

I want to create a spreadsheet where column A has a list of numbers and column B has the totals. I want to create a formula where the difference between each cell in column A is displayed in column B, ...
0
votes
0answers
8 views

Named Views for Excel Pivot Table?

While I'm an advanced Excel user and developer of addins, I apologize that I'm not very familiar with pivot tables. I have a simple pivot table worksheet based on a simple set of data in another ...
2
votes
0answers
22 views

Remove a known Excel password without Excel

Is it possible to remove a known password from an excel sheet if excel isn't installed on the machine? We receive uploaded excel files (2007 and 2010 format) and we know the password for those excel ...
0
votes
1answer
23 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
0
votes
1answer
18 views

Formula to return values into a number of cells based on another cell's value.

If I have a cell (A1) value is "2" (set value) & another cell (A2) value is "4" (number of cells in 1 column i want the set value to appear in) How do I return the values in B1:B4 to all be "2"?
-1
votes
1answer
10 views

Fixate scroll in excel

How do I "fixate the scroll" at line 27 as khan did in this excel spreadsheet? https://www.khanacademy.org/downloads/buyrent.xls
2
votes
2answers
18 views

Moving Right When Dragging Formula Down

I have a SUMIF formula as follows: =SUMIF($B$2:$B$5758,">1",N$2:N$5758) Is it possible to make it so that when this formula is copied down the formula becomes =SUMIF($C$2:$C$5758,">1",N2:N5758) ...
0
votes
0answers
20 views

Keep header text in Excel, but change font

I've seen several examples for changing the header font in Excel; however none of them just change the font. They seem to always incorporate static text or a cell reference. How do I change just the ...
0
votes
1answer
31 views

Is there a formula I can use to count the number of occurrances of a name in 1,2,3 order?

I have an excel spreadsheet containing a list of names and "scores" that they have received for a specific date. Each name should have 3 scores each month and I'm looking for a formula that can help ...
0
votes
0answers
10 views

Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...
0
votes
0answers
25 views
+50

Scanning, OCR and adding the scanned numbers

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 ...
1
vote
2answers
27 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
1answer
15 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
23 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
21 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
13 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
29 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
38 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
16 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
17 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
16 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
7 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
20 views

Excel is 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 : A | B | C | 1 TEST | Col | newCol | 2 TEST2 | Col | newCol | 3 TEST3 | ...
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
8 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
33 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
39 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
14 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
25 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
16 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
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
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 ...