Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
0answers
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
3answers
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
3answers
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
3answers
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
0answers
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
1answer
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
3answers
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
1answer
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
2answers
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
1answer
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
8answers
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
0answers
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
3answers
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
5answers
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
1answer
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
1answer
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
2answers
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
1answer
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
4answers
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
9answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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 ...