**1**

vote

**1**answer

17 views

### Embed Excel Chart with Drop-down control into powerpoint

I have an interactive Excel chart which runs on the basis of users selecting ranges using drop down menus via the form control and I want to move this into Powerpoint 2010 for presentation purposes. ...

**1**

vote

**1**answer

12 views

### Is there a way to do a partial text vlookup?

I am trying to vlookup partial text which will return a specific value if found within my data. I have a list of postcodes (zipcodes) and would like a vlookup to look up the first part of the postcode ...

**0**

votes

**1**answer

15 views

### Getting references from regular intervals at regular intervals

I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data: A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3
Sheet 2 data: is blank currently
...

**0**

votes

**0**answers

13 views

### Excel VBA macro - i need to insert column and add a default value to all the cells in that column

I have created a macro but i could not insert columns in it and i could not add values to that coulmn.
I want to insert a column and the default value to that entire column should be CH. column ...

**0**

votes

**0**answers

5 views

### Excel 2010 opening data grouping when entering a formula

When I try to enter a formula in Excel 2010 all the columns that I have grouped/outlined open up. I do not want this to happen. When I open the same file on another computer it does not do this. Is ...

**0**

votes

**2**answers

36 views

### Exporting Attachment File Name + Email Metadata from Outlook to Excel

I am looking to do analysis on all of the file types that I have received in a folder in Outlook. I have tried using the Export functionality in Outlook, as well as importing Outlook directly into ...

**0**

votes

**1**answer

23 views

### AND logic IF statement in excel

=IF((=VLOOKUP(D1700,Cullpitsoriginal!B715:B5480,1,FALSE))+(ISNA(J1700)),"CHECK ME OUT","no")
By looking at the above formula, I want to return the string "CHECK ME OUT" if the VLOOKUP() returns a ...

**0**

votes

**0**answers

29 views

### How to combine an Excel spreadsheet with word documents using a field from the excel rows matching filename of word doc

I am trying to combine an excel spreadsheet with associated word documents. There is 1 word document per excel line.
I have the Excel spreadsheet with all the rows.
I have all the word docs in a ...

**1**

vote

**1**answer

25 views

### Appending Year to Excel Date

I have a pivot table arranged by day and year. Unfortunately, days come up as entries under 'year' headers. Is there a way to make it so that the year is included in the actual entries rather than ...

**0**

votes

**0**answers

10 views

### VBA IE check value with getElementById with style attribute [closed]

I have a div tag with as follows:
<DIV id=ReportViewerControl_AsyncWait style="CLIP: rect(0px 1914px 142px 0px); HEIGHT: 144px; WIDTH: 1916px; POSITION: absolute; LEFT: 0px; FILTER: ...

**1**

vote

**2**answers

52 views

### Microsoft Office 2010 will not open two xls

I am using Windows 7 and Windows 8 and I see the following behavior with Microsoft Office 2010.
Create two Excel files, say a.xls and b.xls
Open a.xls by double clicking it.
After the file is ...

**0**

votes

**1**answer

11 views

### how to get the count of column data based on some condition

I have the excel with two columns like below
ID Address
GID1 address1
GID2 address2
GID1 address1
GID8 address1
GID2 address8
so i want to get , for all same ID's , count ...

**0**

votes

**1**answer

29 views

### Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...

**1**

vote

**1**answer

27 views

### Excell formula for multiple pasts without repeating previous cells

I have a data set for 12 years of 4,380 days. I want to take the sum of each week. when I make a formula {=SUM(A1:A7)} and drag to drop button to the next cell it shows {=SUM(A2:A8)}. This is not what ...

**0**

votes

**2**answers

16 views

### Hide a column when auto filter is active

I have read this Show Excel column filter information in cells and it basically does what it is supposed to. But I want to hide and unhide column A when a filter is active. So I put in the following ...

**0**

votes

**0**answers

17 views

### How do I keep the 'text to column' function from removing decimal points?

After text to column (separated by comma), one column looks like this:
-0.03
-149117279052734.00
-0.05
-0.10
170105123519897.00
253522491455078.00
17897253036499.00
14870138168335.00
although they ...

**2**

votes

**1**answer

15 views

### Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...

**1**

vote

**1**answer

38 views

### Given multiple start dates, how to assign counts to relative date values?

I'm trying to create a before-and-after graph in Excel, lining up multiple milestone dates at month zero, and assigning relative month numbers to months prior and subsequent to milestone month.
My ...

**-1**

votes

**2**answers

32 views

### From date of last event, calculate number of days until next regularly scheduled event

I need to calculate the number of days since last occurrence.
For example, I have to go to doctors every 90 days. My last doctor visit was on 1/9/14. I need a formula to tell me how many days until ...

**0**

votes

**1**answer

19 views

### Have Pivot Chart show only some columns in pivot table

I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself. I then have a pivot table where my ...

**-3**

votes

**0**answers

23 views

### WindoIn excel sorting [closed]

I want to sort in excel by using chart of accounts. I want all numbers that are in position 4 through 8. Using X's or #'s to represent the first four numbers such as XXXX-1000. The first numbers are ...

**2**

votes

**0**answers

9 views

### How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook.
Is it possible to publish this workbook to ...

**-4**

votes

**0**answers

20 views

### vlookup providing inconsistent results [on hold]

I have a vlookup issue, where I am getting inconsistent results from my search.
The table array contains only text but shows only some of the searches and provides #NA for others. I have gone as far ...

**0**

votes

**0**answers

14 views

### Format of file lost in Excel 2013

I had Windows XP and Excel 2008. Now my machine was upgraded to Excel 2013. I lost all the formats from previously saved files used to import info into my accounting package. How do I get the old ...

**0**

votes

**1**answer

30 views

### Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...

**0**

votes

**2**answers

41 views

### Converting comma seperated values in multiple rows

I am in urgent need of importing huge data from excel to SQL.
one of the excel sheet contains data as follows.
ID Name Category Section
1 Books Stationery KG1,KG2,1
2 Pencils ...

**0**

votes

**0**answers

44 views

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

**0**

votes

**1**answer

22 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

**1**answer

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

**-4**

votes

**1**answer

39 views

### Excel Help Please [on hold]

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

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

**0**

votes

**1**answer

18 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

22 views

### how to automate JSON to XML process [on hold]

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

13 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

49 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

25 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

33 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

11 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

17 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

14 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

16 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

**1**answer

29 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

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

**6**

votes

**1**answer

210 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

22 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

30 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

20 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

54 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

69 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

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