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
29 views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
0
votes
2answers
30 views

multiple entries from existing excel file

our customer provides us with an excel file listing drivers names and the number of tickets they get for a free drawing, such as "bill smith (next column) 17 tickets is there a way to take that and ...
-2
votes
1answer
25 views

Display formula result only if inputs are defined

I have a simple spreadsheet, with one row of equations to get sums or differences. What I'm trying to do is enter an equation so that if only one part of the end equation is present, the field is left ...
0
votes
1answer
21 views

Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...
-1
votes
0answers
19 views

MS Excel 2007 Copy Range Across Worksheets and Increment or Offset by 50 rows

I'm looking to copy and paste a list of names from Sheet 1 to Sheet 2 but space them out. For example, I'd like Sheet1!A6 -> Sheet2!A51, Sheet1!A7 -> Sheet2!A101.... Sheet1!A41 -> ...
0
votes
1answer
24 views

Excel - How to add/remove a row without affecting formula in a column

I have column B with a formula full of IFs with each cell referenced to the cell above it. From time to time, I need to delete some rows. Once a row is deleted, the formula in column B gives #REF for ...
1
vote
1answer
23 views

How do I consolidate values in Excel?

I need some help with an Excel spreadsheet. I have a large data set that contains multiple expenses of multiple individuals over time. What I want to do is to consolidate the costs of individuals per ...
0
votes
0answers
12 views

How can I calculate the grouped averages and maximums per day for a range of dates and times?

I have a CSV dump describing the utilisation percentage of some servers in my organisation, covering data samples from several times per day. Each server belongs to a group. For each group, I have to ...
1
vote
1answer
19 views

How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label. The first image is a background ...
0
votes
2answers
37 views

Generate 4 columns of data such that each row sum to 100

If I wanted to randomly generate 4 columns of positive numbers such that the numbers for each row sum to 100, how do I do this in Excel or some other program that you can recommend?
0
votes
0answers
13 views

Avoiding duplicate rows in an EXCEL Pivot Table

I am running EXCEL 2007 and try to do a Pivot table. The data are the following ones: And the table pivot result: As you can see, I have some duplicate lines in the pivot table that I don't ...
0
votes
1answer
19 views

Bit.ly link without http://

I am creating bitly links and want to save them in an Excel spreadsheet. When I copy and paste them I get the http:// component of the address in front of the bit.ly How can I not get this as it ...
-2
votes
0answers
19 views

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

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 ...
1
vote
2answers
30 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
12 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
15 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
22 views

Get differences between two Excel 2007 rows, showing relative changes in second column [on hold]

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
10 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
1answer
43 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
30 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
21 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
12 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
24 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
21 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
32 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
22 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 ...
1
vote
1answer
61 views

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
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
1answer
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
0answers
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
0answers
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
0answers
22 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
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
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
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
0answers
24 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
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
2answers
34 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
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
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
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
1answer
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
1answer
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
1answer
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
2answers
56 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
43 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
17 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
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
2answers
30 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 ...