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)

0
votes
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
4answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
3answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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 ...