**0**

votes

**0**answers

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

**9**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**4**answers

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

**2**answers

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

**3**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**3**answers

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

**2**answers

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

**9**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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