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
1answer
24 views

Excel VLOOKUP with named range not working

I have the following VLOOKUP on a worksheet: =VLOOKUP(D5,FilePurposes,2)&" in respect of "&C5 Where the named range FilePurposes refers to a block of two columns and three rows that look ...
1
vote
2answers
42 views

I need help moving info from one column into another column in Excel

0071 3/4-1 0072 1.5-3 0072 1-3 0072 1.5-1 0072 1-1 Above are part numbers located in Column A and Column B of an Excel spreadsheet. I am trying to combine the columns. Basically, ...
-1
votes
0answers
30 views

which one is the best python plugin for MS Excel? [closed]

I know there is three options available here, data nitron, excel-python, xlwings for these aspects: stable functionality (Can manipulation most MS Excel object, like table,image,chart,etc) easy to ...
0
votes
1answer
23 views

Excel Validation Feature to Return Items from a List

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel ...
0
votes
1answer
16 views

Static Data Input Row for Excel Spreadsheet

I'd like a static data input row in my Excel spreadsheet. This row would allow the user to submit a row of data and press Enter or a Submit button to have the row added to either the bottom of the ...
1
vote
1answer
34 views

Sumif & Indirect

In using the following sumif/indirect function (=+SUMIF(INDIRECT("'"&$A$3&"'!$B$2:$B$102"),$C13,INDIRECT("'"&$A$3&"'!F2:F102")) my columns (F:F) wont move as I drag the formula to ...
0
votes
2answers
47 views

Removing commas from CSV file

I created an Excel .XLXS file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file. Once I did that, the ...
0
votes
0answers
22 views

Windows 7 and excel copy & paste

I have trouble using the right mouse to drag and copy several fields in excel at one time . I am using excel 2013. I will start highlighting by dragging my mouse over the the fields I want to copy, ...
1
vote
3answers
24 views

Splitting Data in Excel Based on Character Location

I have a column of data, each row containing a set of 83 characters (e.g. 010203 344345 929348238482abcde33 4566) with no particular pattern that needs to be split into blocks of different lengths ...
0
votes
1answer
17 views

How to gray-out cells when N/A is entered

I have an Excel sheet used as an order form. I need to know how to gray out a number of cells if an N/A is entered. My problem is that if an N/A is entered in to cell D13, cells E13 to E15 to gray ...
-2
votes
0answers
14 views

Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have? I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...
-1
votes
0answers
13 views

Page Layout Tab Freeze [on hold]

I highlight the work sheet than click on page layout on the excel ribbon on top of the sheet. The page layout "tab" does not want to respond. This happens intermittent. What is the problem and how ...
1
vote
2answers
32 views

Increment numbers inside a text in microsoft excel 2007

I would like to drag cells downward and increases the number next to letters. It work when there is no letter for me. For example, I want to increment the number this way AG1 AG2 AG3 AG4 ... I ...
2
votes
1answer
21 views

Multiple data points in a graph's labels

I'd like to build a bar graph in excel. The thing i'm having issues with is the formatting of the labels on the datapoints. I'd like the labels to pull from 2 datasets. The bar would be drawn using ...
1
vote
1answer
34 views

Replacing similar terms with one word in Excel

I apologize in advance, because I'm not entirely sure how to word this question. I'm maintaining financial records for a student organization, and my goal is to make a spreadsheet that is easy to ...
1
vote
3answers
37 views

How to split and distribute columns like “A,B,C” and “X,Y,Z” into “A,X,B,Y,C,Z”?

so this seems tricky to me but i have a set of data that need to be split into alternating comlumns here is what i mean is in the example below i split column A to C E and G ect depending on how many ...
1
vote
2answers
19 views

When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link: http://web.utk.edu/~dhouston/excel/exam1.pdf to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...
0
votes
1answer
41 views

How to combine data set to create unique combinations [duplicate]

First of all I don't have experience with Excel scripting, just basic formulas. I've seen this other question on SU but I'm not sure if that's exactly what I need or how to adapt it to my needs. ...
0
votes
0answers
14 views

Fuzzy Lookup Add-In

I hear it is a faux pas to hijack another post in order to get help with my issue, so I'll just post a link to that post and hope for the best: Comparing Similar Text Strings in Excel So, I'm trying ...
-2
votes
0answers
20 views

How do I set MOUSE 4 and MOUSE 5 to do functions in Excel 2013?

I have a five button mouse and I want to assign functions for the side buttons inside excel. Functions I have in mind are both Ribbon functions and I use Excel 2013. I've seen some tutorials online ...
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
45 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
42 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
42 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
20 views

Excel Formatting Columns to show amount NOT carried across [closed]

I have a column (D) which has an amount in it ... this amount needs to be carried across to one of 25 possible other columns (E - AB) - I want the column D to highlight until such time as the amount ...
0
votes
1answer
22 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
41 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
23 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
40 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
56 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
32 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
39 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
25 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
43 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
471 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
24 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
16 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 ...