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 "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
18 views

Equivalent to Excel 2013's 'BeforeSave' for Excel 2010?

I am trying to have a housekeeping macro run when an Excel sheet is saved, but I can only find reference to this: https://msdn.microsoft.com/en-us/library/office/ff840057.aspx for Excel 2013. Does ...
0
votes
2answers
14 views

Loop down column until blank cell

The following formula works well if I define each cell (over and over), but I need a loop that will run down column A & B for hundreds of rows. I have tried and just cannot seem to be able to ...
0
votes
2answers
4k views

Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...
0
votes
1answer
11 views

In Excel, how can I make a row of data in a table that has specific text in one cell automatically appear in a table on a seperate sheet?

I download a report with 8 columns of data into a table each week. The amount of data changes each week by row (one week might have 40 rows, the next might have 100 but no more than 150). The data ...
1
vote
1answer
10 views

How can I custom format in excel to place periods (as separators) in an 18 digit entry?

This is regarding 18-digit accounting codes that contain multiple periods, as separators. I would like to enter just the digits without typing in the periods. Example: 112233333444555556 would ...
0
votes
2answers
26 views

Excel - Sum assigned numeric value of 1 to different phrases in different cells in a row

I'm assessing a survey of multiple choice answers using Excel. I need to assign a numeric value of 1 to fixed text answers and show the sum on another worksheet in the same workbook (the text is ...
0
votes
2answers
658 views

Disallow saving an Excel spreadsheet

Is it possible to disallow saving an Excel (.xls) file? (Should also work in Numbers on OSX)
0
votes
2answers
4k views

Copying data from an entire column in excel worksheet into another worksheet minus blank cells

Instead of using a copy and paste function is there a way to lookup data in an entire Column rather than an individual cell in one spreadsheet and list it in another ( minus the blank cells )so it ...
1
vote
2answers
1k views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
2
votes
3answers
9k views

Formula to move data from every third row to a column?

I have an excel sheet (mac, Excel 2011) that contains names (1st row), job titles (2nd row), and company/institution (3rd row) in one big column. I am trying to separate them into three different ...
0
votes
0answers
23 views

Easy way to convert one row of data into multiple in Excel

I have a worksheet that looks like this: Right now each Number contains a varying amount of Companies and Company Numbers. I would like to set up the spreadsheet so each Company has their own row ...
-1
votes
1answer
33 views

Formula to return “N/A” when other cell value is “No”

How do I get one cell to come up with "N/A" when "No" is selected from another cell's drop down?
0
votes
1answer
12 views

Merge two sheets on two columns into a new sheet in Excel?

I'm using Excel 2011 on OSX. I have Sheet1 that looks like this: pupil_id date test_score 1 2015/10/01 98 2 2015/10/01 83 And I have Sheet2 that looks ...
0
votes
1answer
25 views

Formatting an Excel spreadsheet

This is what I want excel to do= If column F says SP then turn column M - same row - a colour if the year is less than 2011.
2
votes
3answers
4k views

Fix a (Today) Date in Excel

I have a file with a VB macro that puts a TODAY() formula in a cell when I click a button. The formula is volatile and updates every time the sheet is calculated. Instead, I would like to lock the ...
0
votes
1answer
18 views

Excel VBA - Getting “Object Required” Error When Stating Range Is Not Null

Below is my code where I'm getting the error. I've marked the line that the error occurs on in bold (i.e. ** at the beginning and end of the line **). The specific part of the code I'm receiving ...
5
votes
1answer
11k views

In Excel, how do you auto fill until next value?

currently I have a column looks like this: A B ... 1 A 2 3 4 B 5 6 7 C 8 ... And I want to make it looks like this A B ... 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C ... Is there a way to finish the ...
2
votes
2answers
3k views

How to export data from Excel to SQL Azure?

I know how to import data from SQL Azure into Excel From Excel go to: - Data - From Other Sources - From SQL Server I want to manually edit data and post it back to SQL Azure. What is the ...
62
votes
8answers
131k views

How do I join two worksheets in Excel as I would in SQL?

I have two worksheets in two different Excel files. They both contain a list of names, id numbers, and associated data. One is a master list that includes general demographic fields, and the other is ...
0
votes
3answers
12k views

How do I group a colum sort in Excel by year and then by month?

I have a basic Excel 2013 spreadsheet I use to track appliance retirement for an apartment complex. I am trying to get a column to sort by months for a give year. This is currently what I see: What ...
1
vote
2answers
8k views

Excel crashes everytime when saving a specific file

The instant I try saving a particular excel document excel will crash. How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it ...
0
votes
1answer
15 views

Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled

I'm trying to adopt the solution from this post & I've modified the macro slightly (I only need to add on button click) so that it's now Sub AdjustValue() Dim btnName As String Dim ...
1
vote
1answer
29 views

Excel - base 27 three-digit Sequence enlisting

In a three-digit number increasing sequence, where the base of each number is 27, I am trying to make a list of all combinations, but without repetition of numbers. E.g 1,26,26 would not be an option. ...
0
votes
1answer
20 views

Referencing a worksheet in a formula in Excel 2010

I am using Excel 2010. Let's say I have a workbook that contains 13 worksheets. The first worksheet is named "Summary" and the remaining 12 are the months of the year (January-December). In ...
0
votes
0answers
25 views

Excel - Decision-Tree Budget / Shopping List

I'm planning the purchase of a bunch of A/V equipment. There are lots of different options for where we might end up. Some of the equipment is base equipment, we need it no matter what. For some of ...
3
votes
4answers
13k views

Unable to enter anything into a cell

While working on a Excel for Mac, I suddenly cannot enter any data in ANY cell. Also the same thing with all my spreadsheets, unrelated to the one I was working on. I can type numbers and letters on ...
1
vote
1answer
11 views

Using address function to create array excel

I'm trying to create an array using address to find the max value from a different sheet =address(10,15,1,true,"othersheet")&":"&"address(11,20,true,"othersheet") returns this ...
0
votes
3answers
34 views

Printing multiple sheets with Mail Merge (Excel/Word)

I need to create letters with MS Word. On each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to find a way to ...
6
votes
5answers
3k views

How to combine data from two rows, when certain criterion is met

click to enlarge I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...
0
votes
0answers
13 views

Combining multiple lines and selecting farthest date range

What I have is a spreadsheet with customers listed multiple times and need to condense data per customer to one line in 3 different columns. The columns I am trying to do this function is L, M & ...
0
votes
0answers
12 views

How to reset Excel 2013 Spreadsheet Compare

In Excel 2013, I have the Inquire COM Add-in turned on, which gives me the 'Inquire' ribbon. I can click on the Compare Files button, which launches the Spreadsheet Compare tool. In the bottom ...
0
votes
0answers
14 views

Cleaning up data fetched from Google Spreadsheet to Excel

I've been trying to synchronize and build a local database with Excel data. I need to build the database and program to create user accounts, manage the packages, track and log the status of the ...
0
votes
2answers
22 views

Nested countif's frying my brain

What I want is the following scenario: If all values are "Pass" then display "Passed" If all values are "Fail" then display "Failed" If all values are "Incomplete" then display "Not Started" If all ...
0
votes
1answer
8 views

Excel: How to obtain depured colum B after deleting matching values from column A

So I have in Column A a Blacklist of sites that i can not use any more In column B i have listed all of my current sites (more than 5000 rows). So i need to look if any of the values of column A is ...
0
votes
0answers
22 views

Merging two cells together with same data

I have a spreadsheet of about 23,000 user ID's in one column. Then in the very next column I have a list of about 1300 user ID's that use a particular application. I need the 2nd column to sort ID's ...
0
votes
0answers
12 views

Create a checkbox that will hide rows containing a specific string of text (Excel 2013)

I'm working on a sheet to help me track the progress of projects as I work on them. This is accomplished by keeping information in an ongoing table, columns A through N. I want to keep a running list ...
0
votes
3answers
398 views

Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: - Landline Nos e.g. 02012345678 to appear as 020 1234 5678 Mobile Nos e.g. 07123456789 to appear ...
0
votes
0answers
14 views

Create Hyperlink for open and filter worksheet

Is there any way to open worksheet with filter data? through hyperlink I have One "main" worksheet, from there through vb coding it will create two worksheets (If exist then delete and re-create.) 1 ...
0
votes
1answer
26 views

EXCEL SUMIFS with dynamic tabs (INDIRECT)

I'm trying to get below SUMIFS formula to work with INDIRECT. I have data for each week in separate tabs .. ie WEEK05, WEEK06 etc. The result of the formula (a date) will come from column W based on ...
1
vote
0answers
27 views

Calculating partial values for use in a weighted average

I have a spreadsheet with the following information: Column A contains a list of courses (eg Course 1, Course 2, etc) Column B contains the number of credits available to each course Column C ...
0
votes
1answer
36 views

Change color of row according to column value (by regex)

I'm quite new to excel so this could be dumb question. I need to change color for those rows which has suffix .com in their second column. I use OpenOffice but I can change it using Microsoft Excel ...
1
vote
0answers
23 views

Excel search function search term from other sheet [duplicate]

I have an excel sheet with a function which uses the SEARCH function in the following way: =IF(OR(IFERROR(SEARCH("TERM1";MYCELL;1);0) > 0;IFERROR(SEARCH("TERM2";MYCELL;1);0) > ...
0
votes
2answers
45 views

Copy multiple Excel workbooks into one workbook

I am trying to copy multiple Excel workbooks into a single workbook with each of the copied workbooks to have their own Tab. I do not know how to use VB, so I have tried many VB scripts I found ...
1
vote
3answers
2k views

Fast way to export data out into different excel files based on Column

There's some data like this (with over 500,000 entries) Name | State ---- ----- Billy Utah Sue California Joe Utah Sally California John Michigan ...
0
votes
0answers
9 views

view formulas in Excel in read-only (license expired) mode

On license expiry, Excel claims you can still look use office to view your files for free. When I try this, though, I am unable to view formulas. They don't appear in the formula bar. Ctrl-\ ...
0
votes
0answers
41 views

multiple IF conditions and answers

This is a cashflow spreadsheet. I want the column next to the expenses column to show me the source of the expense. The expenses are arranged in spreadsheets, so for example; checks, taxes, general ...
2
votes
2answers
22k views

How to force Excel to open CSV files with data arranged in columns

I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma: 1,2,3,4 1,2,3,4 The file is sent via email and I want that when a customer opens it ...
0
votes
1answer
2k views

Add a row in excel based on criteria

I have a very large excel spreadsheet 2000+ rows deep. I am organising it by adding a blank row each time the first word in Column C changes; I have been at it for over half an hour now and this got ...
0
votes
2answers
2k views

Excel: AVERAGEIF on multiple work sheets (via 3D Reference)

I have a question when using excel averageif functions: I have a workbook containing monthly information (stored as numerical values) in 12 different worksheets (named Jan, Feb,..., Dec). In each ...
1
vote
2answers
3k views

On Unix, open xls file, and read the content, only the data

Does any one know how to open xls file in shell on UNIX? whether is there any tools to convert XLS to CSV?