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
348 views

How do I find which Pivot Tables has an error in Excel 2010?

I'm receiving an error: cannot open PivotTable source file ...XLSX SHEET... while refreshing all data. I have many Pivot Tables, and I can't find that one with the error, while refreshing ...
0
votes
1answer
396 views

Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula. I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need. In column A I write the ...
7
votes
5answers
3k views

Excel 2013: “We couldn't free up space on the clipboard. Another program might be using it right now”

Excel 2013 often complains that "We couldn't free up space on the clipboard. Another program might be using it right now" when I'm trying to copy cells. Some say it might be caused by Zone Alarm or ...
-1
votes
2answers
61 views

Finding a unique value in excel

Lets say I have two columns, A, B, and that the A column is in order from lowest to highest. A | B 1 | 1.1 2 | 1.1 2 | 1.2 3 | 4.5 3 | 9.6 4 ...
1
vote
1answer
3k views

Change Value of Excel Cell when another cell contains specific character

I created a multi-sheet Excel workbook to track workouts. Page 1 is a calendar with clickable links to each other page. Each other page is a specific type of workout. So if you click today's date on ...
-2
votes
2answers
69 views

Graphing in Excel

I am trying to make a stress strain diagram in Excel, and I am getting a weird result. Excel is plotting the data, and plotting a line from the last data point back to the origin. Can anyone help ...
0
votes
2answers
351 views

CountIf()-data from different workbooks

I am trying to take data from two separate workbooks laid out like so: picker | lines --------+------ zf | 4 ag | 22 jw | 8 zf | 7 cr | 39 ag | 10 ag ...
0
votes
2answers
85 views

want to extract email address from a string of characters — pretty close [duplicate]

I am close to the end, I just need to add something in to remove the open and close parenthesis and then add a semicolon. I got this far by googling; I just need one more piece to the puzzle. :) ...
0
votes
0answers
35 views

MS-Excel: reference to a cell in an external file

I would set a matrix in a worksheet including values coming from external files. I would obtain the reference not in a direct way, but I would address the cell nto this way: ...
1
vote
2answers
260 views

Excel: return name of column with highest value in a non-continuous array

I have looked up many answers to find the highest value in a column, and return the column name. However, every answer is dependent on using a continuous array and uses the INDEX function. This is ...
0
votes
2answers
538 views

Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...
0
votes
1answer
869 views

Excel: Remove only alphabetic characters (retain special characters)

Two datasets to compare. 6701.2345_5432 and on the second the system inserted letters. 6701E.2345_5432 I have about 8000 rows I need to compare and I can't seem to modify the VBA code to ...
0
votes
1answer
33 views

Conditional Formatting with Office 2008 for Mac

I'm working with a 2,000 line spreadsheet in which I want to isolate certain lines based upon certain key words in descriptions contained in the 1st column. I have tried using Conditional Formatting ...
1
vote
2answers
38 views

Copy Columns until a boundary

Am trying tell VBA to copy all the cells from Column "Data_FirstCoumn" until "Data_Boundary" Column. However VBA keeps throwing up an error stating that "AutoFill method of Range class failed". ...
2
votes
1answer
13k views

Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data: Date (from 1st till 31st) Variable 1 variable 2 I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis, I plot the date on the graph ...
0
votes
2answers
1k views

How do I require a cell in one column to have a value if a cell in another column (same row) has a value?

I'm trying to require a value to be populated in column A if column D has an amount in it. Column A can hold any type of value (text or numerical), column D can only be a number. So, for example, if ...
0
votes
2answers
5k views

How do I assign values to text in excel and then add them

For example... I want to assign the value 1 to A, 2 to B and 3 to C and then be able to add a row containing a combination of A, B and C's? A B B C B C A = 14 Need some help... Thanks!
4
votes
1answer
101 views

Strategy to easily update incoming external links to an excel workbook

Lets say you have 2 workbooks Name "PrivateWorkbook" and "PublicWorkbook" PublicWorkbook is accessible to everybody in our company. PrivateWorkbook is only accessible to managers. There are ...
5
votes
2answers
638 views

Allowing users to unhide (format) only chosen columns

TL;DR, what I want to achieve: Hide some columns which I do not want to show to anyone (check) Hide some columns which I want to show only to some users (check) Set separate passwords for both ...
1
vote
1answer
69 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
0
votes
2answers
559 views

How to add 4 hours in a format cells as yyyy-mm-dd hh:mm:ss and fit year,month and day

How to add 4 hours in a format cells as yyyy-mm-dd hh:mm:ss and fit year,month and day. Example below.
1
vote
1answer
47 views

How to insert delimiter into text that is in a specific format

I am currently using Microsoft Excel 2011 for Mac. I am trying to separate data in the following format with delimiters. So far I have not been able to come up with a practical solution. Can anyone ...
0
votes
1answer
300 views

Insert columns, within a range, based on cell reference

So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference. I've managed to get excel to insert columns within my range: Sub INSERT() ...
1
vote
0answers
80 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
0
votes
1answer
67 views

compare and update spreadsheets

Please I need some help with excel spreadsheet here. I have two worksheets, one holding the old records and the other holding the current record. What I wish to do is to develop a vba code associated ...
-1
votes
2answers
97 views

Excel: How to find all cells that contain “photographer” in a long list of links?

How can I find all the rows that column "A" contains the word "photographer" buried in a long URL's that are all different so that I can then extract them from the big list? Here are some examples ...
0
votes
1answer
360 views

Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular ...
0
votes
0answers
104 views

changing excel sheet content depending on cell value

I have to build a dynamic checklist on Excel. The fields (rows) that the user must check will show up depending on the value of another cell (actually a dropdown menu in a cell). This value can be ...
2
votes
2answers
318 views

Insert specified number of columns between two named columns

I am trying to use VBA to insert a set number of columns between two preexisting and defined ones. However, it keeps inserting the new columns to the left of the range. I want to insert the columns ...
2
votes
1answer
2k views

Using VBA to name a cell name box in Excel

I would like to iterate through rows in a worksheet and assign the name boxes of one column (the E column) to the value of that respective row in another column (the B column). I would like to ...
1
vote
1answer
22 views

Excel 2010 switching to formula view after every click

Since I installed Excel 2010 64-bit (was using 32-bit version before), every time I click on an icon in one of the ribbons, e.g. reducing icon size: The top bar switches to the formula view: ...
1
vote
1answer
838 views

Windows Task Scheduler starting Excel in background. How to force to start in foreground?

I'm using Windows Task Scheduler to restart MS excel when it crashes, via an event trigger that runs a vbs script ...
-1
votes
1answer
3k views

IF clauses with SUMPRODUCT

I'm having trouble understanding the following: This works: =SUMPRODUCT(N(A1:A10="Some text");B1:B10) This doesn't: =SUMPRODUCT(IF(A1:A10="Some text";1;0);B1:B10) The N() function converts the ...
0
votes
3answers
109 views

Combine rows in Excel

I have data in column 1 and data in column 2 as follows: 1234 eggs 1234 bacon 1234 toast 4321 Orange Juice I want it to appear as follows: 1234 eggs-bacon-toast 4321 ...
1
vote
1answer
3k views

How do I create a sortable table with merged cells in the header in Excel?

I want to create a table that has a somewhat complex header. The table should look like this: +-----+-----------+-----------+ | | Monthly |Annually | |Item +-----+-----+-----+-----+ | | ...
2
votes
2answers
292 views

Excel VBA Replace Character

I tried looking around for this particular problem, but couldn't find it. I am trying to replace an assortment of characters in a string. I tried looping through the characters using their character ...
0
votes
1answer
26 views

Add reference charts?

Is it possible to add charts that refer to a "base"chart? I have many different pages that need the same chart to display. Each time new data comes in i have to change all of them. So is it possible ...
0
votes
2answers
176 views

Excel multiply days and hours with a factor

I would like to calculate the time span betweeen two dates with excel and multiply the amount of days with a factor - like 2 d and 10 h * 5$ Its easy to get the days and hours by just substracting ...
0
votes
1answer
42 views

Is there a way to copy & paste a format style in Word?

I export some data (daily) from Access to Word and each time, I need to take certain formatting steps (about 6 steps) for the final Word Document. Instead of going through each step, one by one, each ...
2
votes
1answer
63 views

Is there a way to export Excel 2010 files into a Wordpress database as ACTUAL Wordpress pages?

This is a strange question, but I run a magazine in wordpress where I really want more control offline for making a page look right, rather than mucking about with it online. (Long story but, as ...
0
votes
0answers
164 views

Moving cells in Excel 2013 is slow compared to Excel 2007

I am using Excel 2013 with a simple workbook. It contains ~30 sheets, and ~80 rows and ~20 columns per sheet, filled with numbers, and the sum of the rows of one sheet is used as the first cell of the ...
0
votes
1answer
33 views

Enter date in Excel

I'm entering tons of dates into Excel - all for the same month and year just different days. Is it possible to simply enter "20" into a cell and have it populate as "12/20/2013" ?
0
votes
2answers
89 views

How to round down if the result exceeds dollar amount allowed?

I am a teacher currently assigned to computer class. I'm pretty good, but I'm stuck on this. My students are doing a stock market project and I want excel to calculate how many shares per stock they ...
1
vote
1answer
139 views

How to: edit data in excel, visualize it on a second screen whilst live?

Suppose I have the following set-up: I have a laptop connected to a screen. The screen shows whatever. The screen is in front on an audience who are asked to choose between several alternatives, say ...
1
vote
1answer
122 views

head and cat don't recognize Microsoft Excel text files

I have a large .xls file with 53760 rows and 19 columns. I saved it as Tab Delimited Text in order to pre-process it through command line tools and load it into R later. However, when I run head ...
0
votes
2answers
68 views

Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that: =SUM(A1:INDEX(...)) Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function. The ...
1
vote
1answer
2k views

Sum two columns of a pivottable into a third column

excel file pivottable screenshot I have an Excel spreadsheet (above, with screenshot). There are three columns of data, A, B, and C. A fourth column, Combined, simply contains a formula that SUMs A ...
0
votes
1answer
364 views

Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...
1
vote
1answer
39 views

How to print cell value as many times as its neighboring cell value (unpivoting)

I have some data that is pivoted or summarized that I would need to "unpivot". The data looks like this: 1000000 6 1245142 4 1245246 6 I would need it to look like this (each value in first column ...
0
votes
0answers
21 views

is there any macro to save just one column on a template

I have created a template and what i need is to try and keep the contents of one column. so that when i open the template again my closing values on my last spreadsheet are the same as my opening one ...