**0**

votes

**0**answers

24 views

### Showing Zero Values in Pivot Table in Excel

I have an unremarkable pivot table in a completely new workbook. I tried both "For empty cells show 0" in pivot table options and "show blank values" in field settings to no avail. Is there another ...

**0**

votes

**1**answer

16 views

### In Excel for Mac 2011, how do I delete the name from a named cell?

How do I delete the name from a named cell in Excel 2011 for Mac?

**1**

vote

**2**answers

46 views

### Changing Cell Date Formats to Text Format and Retain mm/dd/yy

I need to change cell dates with a general format (mm/dd/yy) to a text format for uploading to Peoplesoft. However I must retain the mm/dd/yy. When I change the cell from general format to text format ...

**0**

votes

**1**answer

45 views

### How do I get Excel to identify a country from city list?

I have a list of data with many columns.
In one column - let's say C, there is a list of cities/places. There are multiple entries, i.e. one city pops up loads of times in a column in different ...

**-1**

votes

**0**answers

6 views

### Autopopulate a templated spreadsheet with another spreadsheet

We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business development strategies. However, the way that we like to look and ...

**0**

votes

**2**answers

47 views

### excel vba codes user form

I have created a user form for my work book. I would like the user to navigate their way around the workbook using the button on this user form. Is there any code that I can use to limit the user by ...

**0**

votes

**1**answer

40 views

### How to Mirror cells in excel 2013 [closed]

I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...

**0**

votes

**1**answer

24 views

### Excel changing UNC paths in shared workbook

Excel documents stored on network drive, for example, \\networkdata\Excel\Shared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to ...

**1**

vote

**1**answer

42 views

### excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform.
Now I would like a button on the ...

**-1**

votes

**2**answers

35 views

### Trying to use SEARCH function in Excel

I'm trying to do something on Excel which is a little bit over my head and was wondering if anyone out there can help:
I'm trying to search through a table (specifically one column) for several ...

**1**

vote

**1**answer

24 views

### Create an animated plot of data points from csv

I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates.
I want to create an animated plot of point where the point is moving acoording to the given ...

**0**

votes

**0**answers

17 views

### Excel has quit opeing files properly on my Windows 8 computer

I installed Microsoft Office 2013 on my computer and all of it has been working great until recently. Now when I try to open an Excel program that has previously worked just fine, all I get is the ...

**0**

votes

**2**answers

19 views

### Auto-increment cells for named rows and named columns

I am looking for a way to reference cells inside named range and have it be understandable for person looking through the spreadsheet.
I have this spreadsheet:
A B C D E F G H
1 ...

**0**

votes

**2**answers

41 views

### Excel- Generate a list from single cell input

My question is basically how can you generate a list in Excel based on a single cell input?
For example, the user types 10 then replaces it with 20 and then 30 etc, is it possible to generate a list ...

**0**

votes

**1**answer

20 views

### Excel - How to create multiple named ranges with a fixed size from one column?

I am wondering if there is a way to create named ranges with a fixed size (252 cells) from one column.
I have 51156 numbers in column B. I want the first 252 numbers (B1:B252) to become named range ...

**1**

vote

**1**answer

60 views

### Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate
while true
do
curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1"
echo UPDATED:
date
sleep 10
done

**1**

vote

**1**answer

34 views

### Converting date Jan-12 2015 10:51AM to Date format for sharepoint use

I have a date that imports into excel from an external source as Jan-12 2015 10:51AM, but is not a friendly date format for copyinging into sharepoint 2013 datasheet. How do I convert this in excel so ...

**0**

votes

**1**answer

40 views

### How do I do some minor conversions while importing a chat log into Excel?

I exported a chat log as a comma delimited CSV. From that file, I'm trying to import and format it in Excel.
The file has a field for Date and Time formatted mostly as YYYY.MM.DD HH:MM:SS with some ...

**2**

votes

**1**answer

20 views

### Excel - Exclude Cells from Computation

Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...

**0**

votes

**1**answer

27 views

### How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...

**0**

votes

**0**answers

25 views

### Copy Rows down with value from another Cell

I would like to copy a row of data down dependant on another cell value.
I have a row of data on Sheet one. A user will put a number into cell C2 on Sheet2 say 13.
I would like the row of data on ...

**0**

votes

**1**answer

20 views

### I need to find the difference of multiple cells

I have seven days that will be filled in with weight i.e 180. So i need the +/- to reflect the change in their weight from day to day. For instance I need the +/- to reflect day one and day two then ...

**1**

vote

**2**answers

45 views

### VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table

I'm going bonkers trying to figure this out. I thought I hit the jackpot when I learned about Index match and the additional flexibility over VLookup, but that flexibility doesn't seem to help when ...

**0**

votes

**1**answer

18 views

### Keep Original Sorting of Labels in Excel Pivot Table

I have a list of projects and the quarter that they are to be completed in. I used this data to create a PivotTable that puts a "1" under the column for the quarter when the project is to be ...

**0**

votes

**0**answers

15 views

### turning off read only…have tried multiple avenues

I have 2 separate workbooks that I am hyperlinking. When I try to save the document I get a message that the file is read only and to save a copy. I get this for both workbooks that I am ...

**4**

votes

**4**answers

474 views

### How do I add multiple formulas into one cell?

Here are the formulas I need but I can not figure out how to combine them.
=IF(H4=1,IF(J30<=E29,"Pre-Qualified","Unqualified"))
=IF(H4=2,IF(J30<=E30,"Pre-Qualified","Unqualified"))
...

**0**

votes

**1**answer

26 views

### Cannot copy-paste from-to ranges with filtered rows

I want to copy a given range in Excel, which has rows hidden due to filtering out, into another range which has other rows filtered out.
I applied the usual procedure Ctrl+C, Ctrl+V.
It is as if it ...

**1**

vote

**2**answers

33 views

### How do I create spreadsheet that will alert me when a quantity drops below a certain threshold in Excel 2010?

I am trying to make a sort of "inventory helper" spreadsheet that can track quantities. On the summary sheet, I want to be able to enter a quantity into a column called "On Hand" and then if that ...

**0**

votes

**1**answer

17 views

### Using the text values from one column to lead to output in another

I have a list of cities in one column, Column C.
I have a list of countries which relate to each of those cities. How do I get Excel to look at the Column C, compare to my list of countries (I can ...

**0**

votes

**1**answer

29 views

### How to update multiple excel files?

I have one Master excel file called "00" containing 3 sheets "00", "01", "02". This Master file "00" will be managed by one user. I need to have 2 separate excel files called "01" and "02" that ...

**0**

votes

**2**answers

25 views

### Strange behavior of left arrow key in excel 2013

I saw someone else had this question for Excel 2010, but it was never properly answered and I will be more specific as to what is happening.
In Excel 2013, only when I am working on a PROTECTED ...

**0**

votes

**1**answer

19 views

### Grouping values in a Pivot Table of data containing blanks

I am attempting to group data by range of value to create a histogram.
When I try to group a set of row labels in the Pivot Table I receive the error message "Cannot group that selection."
After ...

**0**

votes

**1**answer

36 views

### Cant lock only the column letter by dollar sign ($)

I can't lock the columns when I extending the variables at the horizontal axis, but vertically it's working great (just like if I don't use anything...):
=$A2
Instead, it's locking everything just ...

**0**

votes

**2**answers

39 views

### Array manipulation in Excel formula arguments

my question is pretty specific, and I haven't been able to find a solution. Here's a sample dataset that illustrates the problem:
First Last Sales Months
Kevin Smith $500 10
...

**1**

vote

**1**answer

26 views

### how to get the array size in ms excel?

I would like to write a formula which returns the size of an array. something like
size(A1:A50)
Maybe, it seems to be strange; but it helps me when I insert some new rows in the first 50 lines and ...

**0**

votes

**0**answers

14 views

### Export animated PowerView scatter chart from Excel

I recently discovered the wonderfully cool capability of Excel to do an animated timeline akin to the type created by Hans Rosling (see his remarkable TED Talk The best stats you have ever seen as ...

**0**

votes

**2**answers

44 views

### Return MAX value of CONCATENATED text using VLOOKUP [closed]

Current formula searches data source for student name and quiz#. If quiz not taken yet, returns blank. If quiz taken, returns data in Column 5. Source data comes from Google form, which is transferred ...

**1**

vote

**0**answers

22 views

### Paste formatting into Excel

I have a script which outputs tab-separated lines that I later paste into Excel (I'm on OS X if that matters) so the end result is a spreadsheet of columns and rows.
Is there any way I can add ...

**0**

votes

**1**answer

36 views

### How to correct floating point round-off error in Microsoft Excel for Macintosh 2011?

I'm using Microsoft Excel for Macintosh 2011 and have a spreadsheet of start and stop time spent on activities with some time differences between start and stop times that are converted into total ...

**0**

votes

**1**answer

31 views

### Conditional Formatting with Unequal Row Elements

I have an Excel table. I want to highlight the rows in which at least one element is different from the others for a given row. How can I do that? An example:
PRODUCT COLUMN 1 COLUMN 2 ...

**1**

vote

**0**answers

6 views

### Widows 7 Ultimate, Office 2010

while working in Excel - Office 2010, i observed that "Insert" tab next to "Home" Tab is missing.
Appreciate help as to how to get it back.I tried Excel Options, Customize and tried to add the ...

**0**

votes

**1**answer

27 views

### m3u playlist remove directories

Simple question here but I'm guessing there's not such a simple answer.
I'm moving m3u playlists from my PC to my smart phone therefore I mass change the directories to suit (see below) as the files ...

**0**

votes

**3**answers

37 views

### Average Sum of Pairs of Numbers in a Column

Suppose I have a column of 10 numbers and I want to know what the average of the sums of each number with each other number (except itself) is. So it would be the average of the sum of, for example, ...

**-1**

votes

**1**answer

27 views

### Extracting rows in an Excel worksheet where there are duplicates based on selected columns

I have an Excel worksheet where there are multiple records (rows) and I wish to create a new "tab" (worksheet) by removing the "duplicate, triplicate etc." rows based on checking for identical ...

**0**

votes

**0**answers

27 views

### Expanding abbreviated text with Substitute formula in Excel

I have a spreadsheet contains a list of 24k items found in a grocery store. Most items have abbreviated words such as: w/ for with; choc for chocolate; sauv for sauvignon. Yet the list contains both ...

**0**

votes

**0**answers

16 views

### How can I copy new data with additional rows, while including formulas?

As an example I have data in the range A1:D55 and in Column E I have a formula using vlookup in reference to column A.
I pull the data again for A1:D55 and the values change (titles remain the same) ...

**0**

votes

**1**answer

85 views

### Excel 2013 32bit and 64bit crashing on form

Excel 2013 32bit and 64bit crashing on user form.
I don't know what's wrong with this form. Does anyone see any problems? Is there a change in codes, value, attributes from Excel 2007 to 2013 that I ...

**0**

votes

**1**answer

18 views

### How to separate the last part of the string in Excel?

I need to separate the last part of the string that comes after the last "/" symbol.
For example:
http://superuser.com/questions/ask -> ask
...

**0**

votes

**1**answer

26 views

### Compare multiple columns with the same values, but some rows missing

I am downloading ranking data from Google Webmaster Tools for specific time periods and it looks like this (columns):
Keyword - Position
The Keywords differ for each time period, as well as the ...

**0**

votes

**0**answers

13 views

### Mail merge doc doesn't automatically link to data source

I have a mail merge doc that when opened, doesn't give me the "opening the document will run the following SQL command" message. Once I'm in the doc I have to do Select Recipients" & then connect ...