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

Excel, can't figure out how to construct this formula. Search rows containing a certain value for other values and comparing them

Here is what I'm trying to do: This spreadsheet contains 40k+ component serial numbers. These assembly serial numbers are in column c. These components contain sub assemblies and those also have ...
41
votes
9answers
142k views

Convert a column into a comma separated list

I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this: 1234 123461 123151 11321 And make them into a comma-separated list in another cell ...
0
votes
0answers
5 views

Simulating iterations multiple times?

I'm super new to using Excel, so I don't really know where to start with this problem. I have a bit of a simulation as shown below, but I want to "use" it about 100 times, with different demand ...
0
votes
0answers
9 views

Formula to determine available options based on prerequisites

Example: A spreadsheet for a single studient has four columns: Course|Completed?|Prerequisites|Available The "Course" column lists the names of courses. The "Completed?" column indicates a "yes" if ...
-3
votes
1answer
19 views

Excel Help Please

I need an excel macro that will pull specific cell data from multiple workbooks and update specific cells of another workbook and fill in cells in the order the files are in the folder. I have built ...
0
votes
2answers
10 views

Removing duplicates in a table based on multiple column values

| A | B | C | D | E | | Product code | Length | Width | Height | Weight | I want to remove a row if all the values in that row are duplicates else where. Note that ...
-3
votes
1answer
73 views

Excel - sumproduct/sumif [closed]

I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my ...
0
votes
1answer
5 views

Drag excel array formula left then down

I have an array formula below: =INDEX(Sup_Missed!$A$4:$FV$78,MATCH(Sheet9!$A$4,Sup_Missed!$A$4:$A$78,0),MATCH(B3,Sup_Missed!$A$4:$FV$4,0)) What I did is dragged it left that is why i left the ...
0
votes
1answer
27 views

Can I use a worksheet as a function in Excel?

I have a worksheet set up such that I can input a value, do some math to give me a bunch of values, repeat math a few times, and add up all the values and return an output value. It is complex enough ...
0
votes
1answer
13 views

Excel - Find a specific column in a CSV file, and copy to the current sheet

I get a regular data export in a CSV format, which I like to pull into excel and report on via helper columns and pivot tables. I do this by linking to the csv file, and copying the cell contents ...
0
votes
1answer
19 views

Match first and last name to 2nd column then output corresponding 3rd value

I'm trying to create an import csv. the sheet has the following data ImportID, 1stname, lastname, FirstName, LastName, inport_ID 1, bob, Abraham, bob, Abbott, 2, sue, Abraham, bob, Abraham, 1 3, ...
0
votes
0answers
15 views

how to automate JSON to XML process

I have link to JSON URL. Each JSON link have unique ID at end of URL. so all of them have different data but same tag name in it. example. example.com/catalog/movie/1005218 ...
0
votes
1answer
1k views

Merge Multiple Excel File

I need to merge a few hundred Excel files into in one Excel file. Each Excel file needs to be merged into its own worksheet in the workbook and the worksheet it's merged to needs to be have the name ...
0
votes
2answers
25 views

Specific Row Values in Excel

How can one ask Excel to record the value of all cells in a given column such that the row number is of the form row = 2^i for i in 1 to 100? Would this necessarily use VBA?
2
votes
2answers
61 views

Alphanumeric sorting in Excel

In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11? Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...
0
votes
0answers
13 views

Data in excel being copied into a gmail note

Up until last week, I was able to copy and paste data from an excel spreadsheet into a gmail email and the text would come in as rich text, keeping the formatting and the hot links active. Now when I ...
2
votes
0answers
18 views

Microsoft Excel to SQL using Pentaho: syntax error in 'OPTION SQL_SELECT_LIMIT=DEFAULT'

I've been using Pentaho Kettle version 5.1 to transfer Excel data to SQL by following these steps (answered by Edgar: Launch Pentaho Kettle (Typically) click on 'No Repository' Create a new ...
0
votes
2answers
4k views

Comparing columns in two different excel sheets and if they match copying third column

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem. I have two different work sheets (say F1 and F2) with last name in Column A, first name in Column ...
1
vote
2answers
7k views

Excel 2010 pivot table/chart - how to filter a date range without empty rows

I have an Excel 2010 PivotTable pointed to some data in the workbook that includes a date. I can group the date field into year and month just fine. What I want to do is produce a chart of a filtered ...
1
vote
1answer
2k views

Excel scatter plot with multiple series from 1 table

Say I have a table as follows: Label | X | Y | A | 1 | 1 | B | 2 | 2 | B | 3 | 2 | A | 4 | 3 | C | 5 | 4 | A | 4 | 3 | C | 2 | 1 | How ...
0
votes
0answers
9 views

How to embed an icon from one worksheet to another, within the same workbook

Does anyone know how to embed an icon referencing another worksheet page onto another worksheet ... all within the same workbook. I have been trying this out but keep getting information on how to ...
6
votes
4answers
18k views

Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...
1
vote
2answers
26 views

Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet. First Sheet: (yes I need these merged cells) Second Sheet: Unfortunately Google ...
1
vote
3answers
2k views

CTRL+D in Excel 2010 fills values and formatting, but I want it to only fill values/formulas

When you press CTRL+D in Excel 2007 or 2010 (and probably older versions), it makes an exact copy of the cell above it (modifying cell references, of course). In doing so, it copies everything else ...
1
vote
2answers
2k views

Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values. I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
2
votes
2answers
4k views

In Excel how can I sum all the numbers above the current cell?

I want to have a column in Excel that consists of a header, a bunch of numbers, and then have the sum of those numbers at the bottom. I'd like the sum to adapt to the insertion of new numbers above ...
0
votes
1answer
2k views

Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language In version 2007 as I can remember we had an option in the advanced options tab that allowed us to do that with ...
3
votes
2answers
9k views

Printers not visible in Microsoft Excel

When in MS Word or PowerPoint, when I go to File → Print, I can see all the printers. But when I do the same thing in Excel, no printers are installed. Yet I can use the Ctrl-P shortcut keys and ...
0
votes
0answers
16 views

Extending an formula over multiple cells

I want to set up an excel table where: A:A is my 1st data table B:B is my result table C:C is my "Column" table D:D is my "Row" table E:E is my 2nd data table I want the result of the function to ...
1
vote
1answer
6k views

Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data: Date (from 1st till 31st) Variable 1 variable 2 I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis, I plot the date on the graph ...
0
votes
0answers
11 views

Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in. I am trying to ...
0
votes
0answers
14 views

Trying to make a Bibliography from book database

I try to transform a book database excel to a text bibliography index in word. We need to copy text and formats, in a one line per book text with negrita (for autor), and (cursive) for title, and i ...
-3
votes
0answers
56 views

Compare two cell data and pull the third vaue if both the cells match [on hold]

I have the following 2 sheets, Sheet 1: Customer Customer Name StockCode A00003U AVAGO TECHNOLOGIES SC1865-01-00 A00003U AVAGO TECHNOLOGIES ...
2
votes
3answers
14k views

Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...
0
votes
2answers
21 views

Macro to generate msgbox if user prompted file not found in macro [on hold]

My macro generates a dialog box to prompt user to enter a file name. The related files are stored in C drive and I want to use only the file entered by the user. If file not found, the macro should ...
12
votes
9answers
52k views

Excel Auto-Fill Without Mouse (Keyboard Only)

So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then ...
2
votes
2answers
46 views

Convert a formula in Excel into an Array Formula without Ctrl-Shift-Enter?

Question: How might it be possible in Excel to convert a formula into an array formula, without using a hotkey? Normal Formula Array Formula
1
vote
2answers
46 views

Perform a calculation n times and sum the results (without VBA)

I'm looking for a way to sum the result of a calculation performed a given, arbitrarily large, number of times. Suppose I have 15,000 customers each of whom will spend between $100 and $200, and I ...
0
votes
3answers
35 views

Can't work out the logic for formula

I have two cells and I want to write a formula to check two conditions and return "Error" if either condition is met. The conditions are; 1.Are both the cells empty? 2.Are both cells NOT empty? (It ...
0
votes
3answers
41 views

EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below. ...
0
votes
3answers
4k views

Export spreadsheet and import as table into mysql

What's the easiest way to export a table from either MS-Excel or OpenOffice calc and import it into a mysql database, where: The table will be imported as a table in Mysql The headers of the table ...
1
vote
1answer
20 views

Convert duration text to duration value

I need help on Google Sheets/Excel. I extracted sports results data with the IMPORTHTML function of Google Sheets. All the cells in the Result column contain a duration in the form of "m:ss.00" but ...
0
votes
1answer
15 views

compare three cell values of one excel with other excel work book and return the row data [on hold]

I have two work sheets, I want to identify the row having one key data of workbook A in Work book B and then compare other data of the same row of both the workbooks. and find out rows having those ...
1
vote
1answer
631 views

Check if path to file is correct on Excel Column

I have an Excel file with multiple columns, one of the column has a path to an image in a remote folder (or local, doesn't matter). \\xxx.xxx.xxx.xxx\folder\image.jpg I want to check if all the ...
-1
votes
1answer
18 views

check one column against another and return a third

I'm trying to create an import csv. the sheet has the following data ImportID, 1stname, FirstName, inport_ID 1, Bob B, Bob T 2, sue, Bob B, 1 3, Jill P, ...
0
votes
1answer
3k views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
0
votes
1answer
717 views

How to fix timestamp issue in Excel Graph?

I am working on making a scatter plot in Excel of some temperature data. I have column A containing the date data as mm/dd/yy. column B containing the time data as hh:mm:ss AM/PM and the rest of the ...
0
votes
1answer
2k views

How to concatenate a date in MS-excel and receive a date (not a number)

When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006). How can I display the date also in the formula cells?
0
votes
1answer
2k views

Excel - list values based on criteria

I have a table on a worksheet called "DealSetup" that looks like this simplified version: A B 1 John Doe 1 2 Jane Doe 1 3 Mark Doe 2 4 Doug Doe 1 5 Mary Doe 2 I ...
6
votes
1answer
177 views

Formula does not show superscript character

I have a formula which I want to show a result which includes a superscript character, but I cannot get said character as superscript. Normally I would just enter text into a cell and I can select ...