**0**

votes

**0**answers

6 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

**0**answers

10 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

**0**answers

12 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

16 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

20 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?

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

**0**

votes

**0**answers

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

**0**

votes

**0**answers

10 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

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

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

**0**

votes

**0**answers

24 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

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

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

**6**

votes

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**2**answers

22 views

### Searching a value in a column in Excel

I have values in A1:A1000 and I have another column of values from B1:B500.
I want to check whether A1 is present in B1:B500; if it does I should get as PAID if it doesn't I should get NOT PAID. ...

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

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

**2**

votes

**2**answers

60 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

**1**answer

18 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

**3**answers

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

**-3**

votes

**0**answers

29 views

### INDEX AND MATCH

I am using a formula w/ index and match and it returns data where it should be blank.
help
ex
miles month unit
1000 apr 101
1001 may 101
1001 jun 101
1002 jun ...

**1**

vote

**1**answer

18 views

### In Excel, how do I replace all instances of text in a cell if any of the text matches values from a range of cells)

To make things easy for users of this workbook, I've setup column J with data validation (pulling values from Sheet2) that allows for multiple selections of event types (Academic Calendar, Art ...

**0**

votes

**0**answers

23 views

### Dynamic Bars in an Excel Bar Chart

In a typical bar chart, is there a way to dynamically change each bar color based on a variable? (example: If value is 1 then bar color equal Red, If value is 2 then bar color equal yellow, etc.)

**0**

votes

**2**answers

22 views

### Indexing a sum of values by row from multiple columns

I'm struggling with this one...
In row 2 I have week numbers up to week 9 in this example. Row 1 has a formula that determines to which month a week belongs. In this example, week 5 is in month 1 ...

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

**-1**

votes

**1**answer

33 views

### Excel Macro to do a Sql Query

I need to do a Macro in Excel Worksheet such for the following process.
User will enter a string in the Text field and click a button.
When the button is clicked the VBscript should match the ...

**-1**

votes

**0**answers

8 views

### Run-time error '13' : Type Mismatch [migrated]

While writing a Macro for Concrete Column, I have encountered a "Run-time error '13' : Type Mismatch" Error
Here is the code.
Option Explicit
Sub Pu()
Dim D, b, fck, fy, Es As Double
Dim xi As ...

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

**1**

vote

**0**answers

11 views

### Excel: An indication that a small cell contains more information within that cell

When a cell contains more information than the width of the cell allows, then content is hidden.
Is there any way to show this visually in Excel that this is the case (like an icon or similar)?

**0**

votes

**0**answers

21 views

### Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...

**-1**

votes

**0**answers

14 views

### Automatic generate number series

How to create a numeric series based on an input value
For example: If you enter 3 in the number of types column, it will generate 1,2, 3 to SSiatem# column.
Then enter another number of type say 2, ...

**-2**

votes

**1**answer

21 views

### How to create a numeric series based on input value in excel and repeat it for several inputs [on hold]

I want to create a numeric series based on input value in Excel. For example if user type 3 in column D7, there should be a series of like 1, 2, 3 in column E7. Then continue to enter or type a ...

**-6**

votes

**0**answers

28 views

### Microsoft - Excel [on hold]

I am wondering if you are able to auto fill an order form on one sheet of document with information from several other sheets in the document. For instance, be able to type in the project name of ...

**0**

votes

**1**answer

20 views

### CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...

**1**

vote

**1**answer

37 views

### Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...

**0**

votes

**1**answer

13 views

### How can I set up logic to count the number of occurences in a month for a list of dates?

I have dates that look like this:
9/24/13
9/24/13
10/7/13
10/7/13
10/14/13
10/16/13
10/22/13
10/22/13
10/30/13
I need logic in a cell that will count the number of September occurrences. Then I ...

**0**

votes

**1**answer

7 views

### Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items,
with different information in all columns ,although certain columns might have duplicate information.
I can do conditional formatting and highlight the ...

**0**

votes

**2**answers

19 views

### Drag the cell to create an array of Roman numbers

I need to create an array of cells of roman numbers. So I placed my entry like this
cell A1: I
cell A2: II
cell A3: III
cell A4: IV
I selected the entries and dragged the corner down, hoping that ...

**0**

votes

**1**answer

21 views

### Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well).
In other words, between the ...

**1**

vote

**1**answer

21 views

### Office 365 Excel Online keeps on deleting a textbox

I have a number of spreadsheets on One Drive. If I open them in "Excel Online", the first thing that happens is that the text box which contains the header graphic and title on the spreadsheet is ...

**0**

votes

**1**answer

10 views

### Microsoft Excel 2013 on Windows 7, creating cost based on drop down values

Hi I am need of some assistance and was wondering if anyone can help me. I am creating a spreadsheet for quoting jobs on site and am stuck with a particular part.
I have a cell containing a drop down ...

**-1**

votes

**1**answer

18 views

### Assign the value of a cell as a cell reference of another cell in Excel - How to? [on hold]

The intention behind this query is to simplify the review of excel sheets with engineering calculations.
Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 ...

**0**

votes

**2**answers

19 views

### Computing time difference to fraction in excel

Consider an employee working 8 hours a day (9AM-6PM), and came in 9:25AM, had a break at 12:00 - 1:00PM and logged out at 6PM. I use a formula to get hours worked (7.58) -
...

**0**

votes

**1**answer

14 views

### selecting elements from a column in Excel

In Excel, I have three columns A2:A100, B2:B50, C2:C50. I want to do the following things:
If An (n is any number between 2 and 100) is in B2:B50 AND Bm==An for some m, then let Dn=Cm.
How can I do ...

**0**

votes

**1**answer

14 views

### Move cursor to specific cell in other worksheet

I put a value in "Sheet1" cell "J2". On running the macro I want cursor to move to "Sheet2" Column "B" and row number as per value put in "Sheet1" cell "J2". Please suggest vba code for the same. ...

**1**

vote

**2**answers

42 views

### Look up a value in a list and return ALL multiple corresponding values

The basic answer to my question is provided here: How to look up a value in a list and return multiple corresponding values. However, once the formula is entered, I need to drag down, or copy/paste ...

**-2**

votes

**1**answer

22 views

### Need an “IF” function that shows whether the difference of a simple subtraction is greater than a certain value

I have values in cells A3 and A2. I will be subtracting the value of A2 from A3. What I need is to be able to highlight or flag the result if the difference is greater than an absolute value of .01 ...

**-1**

votes

**1**answer

22 views

### How do I add two URLs into given format?

I have a excel sheet..That contains two urls sets..I need to add them into this format in another column
Col 1 Col 2
Web site A.1 Web site B.1
Web site A.2 ...

**0**

votes

**1**answer

23 views

### Use macro to email document, and CC another user

I have a spreadsheet with a macro button that forwards the document to a specific user in an email. I have been asked to now have the email send to the original recipient and CC another email address.
...