**1**

vote

**0**answers

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

**1**answer

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

**5**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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