**3**

votes

**1**answer

25 views

### Excel — Tell whether a string contains any value in a table column

Background
I'm using Excel 2013.
I have an Excel table named SiteCategories, with a number of Category columns, and then sites in those columns, like so:
So we could get to those values using ...

**0**

votes

**0**answers

8 views

### Creating Excel range given start cell and row/column offset, in Applescript

I am trying to use Applescript to insert values into cells in an Excel worksheet. The values are held in an Applescript variable as a list of lists (see example code). I've already worked out that if ...

**0**

votes

**1**answer

19 views

### Special format of date in excel

A customer wants a special format of a date column in excel.
What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...

**1**

vote

**1**answer

21 views

### Excel vba to open save as dialog box as PDF

I have the following code, which gives the option to the user in the end to "Print" the worksheet
I wish to modify it. The user should be asked if we wants to "Export it to PDF", if he selects "Yes", ...

**0**

votes

**0**answers

21 views

### Excel T88 error

When a client opens an Excel 2013 file she will get this error.
I have tried to reset Excel and also an Office 2013 Repair but to no avail. Any ideas on what creates this?

**2**

votes

**3**answers

68 views

### How would I increment an alpha field in a table

I would like to increment an alpha field in a table.
a000001
a000002
a000003
a000004
etc.

**1**

vote

**1**answer

16 views

### How can I run a macro changing the value of the cell (no carriage returns)?

I can run a macro whenever a value is changed in a cell. However, I have to press the carriage return button to change the value of the cell. Is there any way to run a macro whenever I press a single ...

**-2**

votes

**1**answer

22 views

### How to transpose range in Excel through insertion of new lines?

My data looks like this:
a 1 2
b 1 2
c 1 2
I want to reorganise it so it looks like this:
a 1
a 2
b 1
b 2
c 1
c 2

**1**

vote

**3**answers

32 views

### How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...

**0**

votes

**0**answers

8 views

### Excel SQL Sort Greyed out

I have an excel sheet with multiple Teradata connections. I am trying to sort/filter the data by description, but I am unable to as the sort/filter button is currently greyed out. I need to keep the ...

**0**

votes

**1**answer

14 views

### Excel 2010 adding to an adjacent cell

I want to add B3 to C3 leaving the answer in C3, I have tried =C3+B3 in C3, a message regarding circular references, I continue and the result becomes a zero

**0**

votes

**1**answer

21 views

### Copy multiple cells (not in range) from one sheet to another sheet

I've searched all over, and I'm unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet.
Eg, Copy Cells, A10, F2, F3 & F34 from ...

**4**

votes

**1**answer

32 views

### How to customise labels on a secondary axis to show student progression as a flight path in Excel?

I am trying to create a line graph in Excel that plots a student's actual progression against their predicted grade. The type of graph is called a 'flight path'. This is represented as two lines on ...

**1**

vote

**1**answer

11 views

### Replace the value of a column based on the a matching value of a adjacent columns

Basically I want to replace the values of the 4th column with the numbers on the second one based on the matching country names.
Country Name Country Code Country Name Country Code
...

**1**

vote

**1**answer

21 views

### conditional formatting based on another value

I need a way to conditional format cell B based on the values of cell A.
Basically I need B to be:
Green if the values are in the same day and within the same hour of A.
Yellow if its one hour ...

**1**

vote

**1**answer

8 views

### How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?

**0**

votes

**1**answer

20 views

### Excel 2010 VBA to remove duplicates and then sumif base on the unique data

My work requires data comparison from 2 different sources (sheet 1 is source 1 and sheet 2 is source 2). Both sheets contain duplicate values (the Delivery Order)
Because I need to do this kind of ...

**0**

votes

**1**answer

9 views

### Share Excel “Template Formulas” between sheets

I have a spreadsheet that takes user inputted values and performs some fixed computations to generate a number of cells. I plan to use these computations in a number of sheets with different user ...

**1**

vote

**2**answers

17 views

### Move each Cell after column A on new line

I would like to export some data into MySQL, however before that I would like to format the data. I am not sure how to explain it, so I made some screenshots.
How could I turn this:
Into this?
1 ...

**0**

votes

**1**answer

32 views

### Convert custom date to standard format

I have a worksheet that has custom dates e.g.
August 26th 2015
and I would like to convert this to
8/26/15
Is this possible ?

**0**

votes

**1**answer

17 views

### Look up specific string in row (not column) and return value of cell x columns left of that location

My data looks like this:
Sheet 1:
A B C D E F
1 2 3 a b c
1 2 3 a b c
1 2 3 a b c
Sheet 2:
A B
a
b
c
Now on Sheet 2 in Column B I would like to return the result of: look up each value of ...

**0**

votes

**0**answers

3 views

### Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...

**-4**

votes

**0**answers

15 views

### extract data in excel [on hold]

I have to extract records to other sheet by key field from a data base in excel sheet using Excel VBA. The code has to go over all records and when the key is Change he takes the next key and extract ...

**1**

vote

**3**answers

30 views

### Excel VBA: Count # of Delimiters

I have the following code:
Sub CopyTest()
Dim skuRow As Integer
Dim curSku As String
Dim numSkus As Integer
Dim impType As String
Dim copyRows As Integer
Dim supAcc As ...

**0**

votes

**2**answers

36 views

### Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc.
I'd like to have a stacked bar chart that lines up with these intervals, but so far ...

**3**

votes

**1**answer

25 views

### Varying Format Part Number Sort Issue

(Current Sort Sample:)
2-1203-4
2-1206-3
2CM-
3-1610-1
3-999
…
AR3021-A-7802
AR3021-A-7802-1
B43570-
B43570-3
I am working on an 8000+ record parts list. The challenge I am running into is that ...

**0**

votes

**0**answers

25 views

### Excel x64 file corruption in .xlsb files for Office 2013

I have a number of Excel files, all created in Office x64, all in .xlsb format and all containing macros. Every now and again, these files become corrupted and I cannot get them to run. I can however ...

**1**

vote

**3**answers

34 views

### How do I use the AND function and the MATCH function together to get something that is not “No” and has not been returned previously

I have the following data and need to return all values that aren't "No".
I.e., I want to create, in another column,
a list of all the values from Column E that aren't "No".
There will never be ...

**0**

votes

**1**answer

27 views

### Check which (multiple) cells in column A contain substrings specified in column B?

In column A I have M&A deal descriptions that mention company names. In column B I have company names, for each of which I want to see where it is mentioned in column A.
What I'm having trouble ...

**2**

votes

**0**answers

21 views

### MS Excel 2013 function TODAY() not updating unless source file is open

I use the TODAY() function in an excel worksheet which is accessed using MATLAB (i.e. I don't read the worksheet directly). Now I have to open the excel file just to update the TODAY() function, and ...

**2**

votes

**0**answers

22 views

### Unlock Excel VBA “Find” window location [on hold]

When editing VBA code the FIND window (Ctrl F) appears at the bottom of the screen. It can be manually re-positioned but upon re-opening it appears at the bottom again. It used to open in the last ...

**0**

votes

**1**answer

23 views

### Match each row against all other rows

I have 53 rows with 25 columns nand it's all txt values. Is there a formula that will match each row against all other rows? I basicaly need a similarity matrix and am wondering if there is a shorter ...

**1**

vote

**1**answer

24 views

### Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...

**-4**

votes

**0**answers

19 views

### I want to develop the splitting one row into multiple rows in Excel

You provided an excellent answer on how to convert Excel data in rows into a vertical column or series of columns. The page is: How do I split one row into multiple rows with Excel?
In that ...

**0**

votes

**0**answers

23 views

### Sum if function - data missed [on hold]

I'm calculating a value based on 3 criteria. One of the values being calculated is incorrect as one of the criteria is not being picked up for one of the lines. E.g I'm counting hours based on ...

**-2**

votes

**0**answers

23 views

### Dynamic text in Word based on Excel output [on hold]

I am trying to print a brochure for clients. The client selects the options from an excel sheet. Based on the selections, i prepare a word output, which has some standard terms and conditions and some ...

**0**

votes

**0**answers

12 views

### Fetch Google Sheets data with Excel Power Query

I am using Excel 2103 and Excel power query.
The fetch data from web works fantastically on most websites, however I cannot get it to work on Google Sheets
I have tried using the share URL as well ...

**0**

votes

**2**answers

63 views

### How to tell Excel that “Years” are “Years”, not data

I have googled everywhere about this but no solution found. I have three columns in Excel:
A: Years, from 1960 to 2013
B: Maize production (in tonnes)
C. Wheat production (in tonnes)
If I make a ...

**-1**

votes

**0**answers

24 views

### Restricting a cell value in Excel

I need to restrict a cell with following two conditions:
text value which equals to APPLIED FOR (11 characters)
alphanumeric value with minimum & maximum of 11 characters
Kindly help.

**3**

votes

**1**answer

35 views

### Excel date month issue

I am working on projects that come in every 4 and a half month. I want to make a calender so I can see when the deadline is for each project.
I have a formula that adds up 4 months and 14 days. (4,5 ...

**2**

votes

**0**answers

38 views

### Excel array formula and structured table date header works with double digits and fails with single digit dates

I have a formula that matches the date with a structured table header row. I have extensive code that deals with the text string nature of this row successfully.
However, when trying to check visible ...

**1**

vote

**1**answer

17 views

### Copy an excel file with Macros and New Tabs in the ribbon to another computer

I'm working with Microsoft Excel 2013. I'm using couple of macros I did and I made a new tab in the ribbon menu which shows the macros I did so that I can click on the this created tab then click on ...

**-3**

votes

**0**answers

30 views

### Excel Formula to show number of months to break even for ROI

Trying to create a formula to determine length of time (in months) to reach ROI.
Column A - Start Date
Column B - Remaining balance until ROI (Investment less current profits) reflects a (negative) ...

**0**

votes

**1**answer

28 views

### Automated Goal Seek - Excel

I have been using goal seek successfully to back into a known number. This works great with a handful of lines - now I need it for 100s (probably 1000s) of lines.
Any help would be greatly ...

**0**

votes

**0**answers

23 views

### Put a new string of characters on a new line after each line break after every new string in a text file

I need to put a new string of characters on a new line after each line break after every new string in a text file.
It is a large list of website addresses that are only seperated by one space on one ...

**5**

votes

**1**answer

42 views

### All Public Variables in VBA Macros in my office stopped working this morning

It turns out, I'm an idiot (or, at least, hopelessly inexperienced with this whole software development thing). The below is what I spent my whole day panicking about. I'll write an answer detailing ...

**0**

votes

**0**answers

20 views

### How to merge/teleport a column

I'm working on an inventory sheet. As I sale items or buy items, I'd like to have one enter point ( or two if needed) to key them in. So if (G5 = sold) then the number enter would "move" to F5(total) ...

**0**

votes

**1**answer

33 views

### How to to divide column containing formulas and hard-coded strings into two separate columns?

I have a column that consists of hard-coded cells as well as formulas. Based on whether a specific cell is either hard-coded or contains a formula, I want to display it in two separate new columns.
...

**0**

votes

**0**answers

21 views

### How can I select two data points on line graph and return its corresponding values?

I have a simple line chart and I want to select any two data points of line and wants in return its corresponding value.
For example, my 11 different points are below. Simple line graph can be drawn ...

**1**

vote

**2**answers

23 views

### Returning a blank cell in MS Excel formula if 2 source cells are blank

My formula in B3 is =A3+B2-B1. I want B3 to be blank if both B2 and B1 are blank also. Could anyone help me with this please?