**1**

vote

**0**answers

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

**1**

vote

**3**answers

29k views

### Looking-up the values of one worksheet in another worksheet

Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.
I have two worksheets in Excel.
Worksheet 1.
Column-A ...

**0**

votes

**3**answers

641 views

### Excel 2010 Table auto expand/formula copy not working

I have a table with around 2k rows, for which I originally needed any formulae copied down into new rows, when they are added. To achieve this, I created a table from the data as many threads stated ...

**2**

votes

**3**answers

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

**0**

votes

**0**answers

5 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

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

**2**

votes

**3**answers

6k views

### Subtracting TIME UNITS (not time of day)

How do I subtract TIME UNIT (not time of day)? Last year I ran a marathon in 48 minutes and 20 seconds. This year I ran a marathon in 47 minutes and 50 seconds. When I do this in Excel- I tried ...

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

**1**

vote

**2**answers

3k views

### Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY)
Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...

**-2**

votes

**1**answer

21 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

**5**

votes

**8**answers

25k views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**1**

vote

**0**answers

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

**1**

vote

**3**answers

16k views

### How to identify cells in Column A that contain any of the values in Column B

First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.
My question is very similar to Find if ...

**1**

vote

**3**answers

15k views

### Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet.
Use ...

**0**

votes

**1**answer

8k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2).
My problem is the percent changes from -4 to +4.
A change ...

**2**

votes

**1**answer

6k views

### Can I save an Excel chart to a PDF document with the chart's exact dimensions?

I want to save (or 'Publish') an Excel 2010/2013 chart to a PDF file whose dimensions will be exactly those of the chart - not a full white page with the chart on it.
Can this be done somehow?
...

**2**

votes

**1**answer

3k views

### Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid.
Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...

**0**

votes

**0**answers

72 views

### How to disable snap/jump scrolling in Excel 2016 for Mac

I'm desparately looking for a way to disable snap-scrolling in Excel 2016 for Mac. Basically as you scroll Excel will continually try to keep the cell you're focused on in the centered. So when you're ...

**4**

votes

**1**answer

31 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

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

**1**

vote

**3**answers

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

**2**

votes

**1**answer

10k views

### How to print an Excel sheet in a multi-colum layout?

In my excel sheet I have three columns A, B, C that are very thin, but have a lot of lines (>500). Now if I print this out, I get 10 pages that are almost empty. Only at the left border of each page I ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

27 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

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

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

**2**

votes

**2**answers

9k views

### Excel tries “Accessing Printer” while opening specific workbook

Excel 2010 (Windows 7 Professional 64-bit) is loading a specific Excel file to 100%, then the status message on the splash screen rotates between "Opening (100%)" and "Accessing Printer". It sits and ...

**1**

vote

**2**answers

4k views

### How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!
This seems to be a common issue:
...

**2**

votes

**1**answer

6k views

### COUNTIFS over multiple worksheets

I am trying to make COUNTIFS go across two worksheets in the same excel file (Final Driver Forecast Model), just on different tabs. I need it to count if a driver returns between a certain time, then ...

**0**

votes

**3**answers

2k views

### Compare 2 columns in Excel and copy data from 3rd column

I'm trying to compare 2 columns that don't have the same size (one has 205 entries, the other 440) and if the data from column B matches the data in column A, the data from column C must be copied in ...

**1**

vote

**1**answer

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

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

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

30 views

### Creating a chq database in Excel

I have made a spreadsheet for printing on business cheques. I was hoping transfer the information into another sheet which will list all of the chq's I have printed. Ideally, I would like the ...

**2**

votes

**5**answers

10k views

### How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening?
I have since deleted the macros, but I ...

**1**

vote

**1**answer

629 views

### Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...

**1**

vote

**1**answer

12k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

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

2k views

### Syncing two sheets, while being able to hide different data

I'm pretty new to excel- so please bear with me.
I have created a spreadsheet to organize gear by serial numbers and by who has it. This list is getting updated multiple times daily as gear shuffles ...

**4**

votes

**4**answers

9k views

### Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question:
28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE"
...

**36**

votes

**9**answers

73k views

### How can I set Excel to always import all columns of CSV files as Text?

Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only ...

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

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

87 views

### Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...

**0**

votes

**2**answers

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

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

**1**answer

3k views

### Excel scatter graph fill inside shape

I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...

**1**

vote

**2**answers

5k views

### Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel.
I have seen a number of examples along the lines of:
retval = Shell("powershell ""C:\MyTest.ps1""", 1)
When I try to use this, ...

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