**1**

vote

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**8**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**4**answers

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

**1**answer

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

**3**answers

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

**5**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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?