**0**

votes

**0**answers

12 views

### Automatically sorting a range of cells after one cell within the range has been modified?

I have a number of named vertical ranges on a spreadsheet, containing lists of names. New names are usually manually added at the very end of each list. Obviously, this means that unless manually ...

**1**

vote

**0**answers

5 views

### Can I use the Excel Match function to match on more than one type of value

In another question I posed recently I was shown how to use the Excel Match function to query my data in order to produce a summary type table:
Creating a formula that queries data in Column B based ...

**0**

votes

**2**answers

26k views

### How do you move between lines in a cell with multiple lines of text in Excel?

If I have a cell that is multiple lines of text, I can drag the top bar down to see all the different lines in the cell, but when I hit enter, the cursor goes out of the cell and onto the next.
How ...

**1**

vote

**3**answers

45 views

### Can I calculate a date using a date plus 53 days, minus any Sundays

Is there a formula tha I can place in Cell L3 that results in a date by comparing the date in cell E7, adding 53 total days to that date, excluding any Sundays within that period. The resulting date ...

**13**

votes

**5**answers

50k views

### Need two excel windows side by side, on different monitors, in the same instance

I have to do work between two spreadsheets and I need to view them side by side.
I can't just open the workbooks in separate instances because I need to make use of features like paste formatting, and ...

**-6**

votes

**0**answers

42 views

### Excel VBA Password and Master Sheet

I need to create an Excel worksheet for my sales team at work. They all need to have their own tab, but the tabs should be password-protected to stop them from seeing each others' tabs. However, I ...

**0**

votes

**1**answer

24 views

### Creating a formula that queries data in Column B based on a selection from Column A in Microsoft Excel

I am reasonably familiar with Excel formulas but I need to construct a more complex query and am not having much success at the moment.
I have simplified what I am trying to achieve for the purpose ...

**0**

votes

**1**answer

27 views

### How to separate non identical entries from two columns of excel sheet

I have two columns in a excel sheet as shown below.
Column A Column B
87 87
107 107
108 108
117 117
119 119
153 153
170 170
...

**28**

votes

**9**answers

29k views

### Is it possible to “unpivot” or “reverse pivot” in Excel?

I have data that looks like this:
Id | Loc1 | Loc2 | Loc3 | Loc4
------------------------------
1 | NY | CA | TX | IL
2 | WA | OR | NH | RI
And I want to convert it to this:
Id | ...

**0**

votes

**1**answer

2k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**0**

votes

**0**answers

16 views

### Excel calculation uses an unlikely high amount of RAM does not release it

I have a sheet that contains about 30 matrix formulas, which are calculating with about 5000 rows of data.
When I calculate the worksheet manually, RAM usage rises from about 400 MB (idle) to 2.5 ...

**1**

vote

**1**answer

11 views

### How to get reference to the only datatable in the active sheet

I am adding a new row to the table I have in the active sheet using the following method:
ActiveSheet.ListObjects("MyDataTable1").ListRows.Add(AlwaysInsert:=True)
The problem is that it is ...

**0**

votes

**2**answers

32 views

### Excel Convert XML cell to columns

I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis.
With ...

**0**

votes

**2**answers

1k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**1**

vote

**1**answer

29 views

### Excel: INDEX and MATCH on rows matching criteria

I want to write a formula that will do the following:
Search for a POS in column C in rows where ID=ID. If a POS is found, output "yes" in the haspos? column, otherwise output "no".
Here is ...

**13**

votes

**14**answers

33k views

### How to make cells perfect squares in Excel?

In Microsoft Excel,
I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done?
Surprisingly, ...

**3**

votes

**1**answer

29 views

### How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function?

In a Google Docs spreadsheet, I can use this cell formula:
=GoogleFinance("GOOG", "price")
to download the latest price of a stock. Is there an equivalent function in Excel 2013?
Earlier versions ...

**-2**

votes

**1**answer

34 views

### How can I remove the #n/a from a complex formula?

=IFERROR(VLOOKUP(AI57,SALESCODES!$B:$G,3,FALSE),(VLOOKUP(AI57,SALESCODES!$C:$G,2,FALSE)))
How do I remove the #N/A on this formula?

**0**

votes

**4**answers

7k views

### My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...

**0**

votes

**2**answers

23 views

### Excel Count number of cells based on three dependent selects

I am looking to count the number of cells based on three dependent select statements. each select corresponds to a column.
For example,
Select nth-Day (Column A)
Select Issue Type (Column B)
...

**1**

vote

**1**answer

37 views

### Why do I get HEX2BIN() error for long (but valid) strings?

In Excel 2010, the formula =hex2bin("111",10) gives the right answer of 0100010001. According to the function help, the arguments should be at most 40 bits (10 hex digits). However, the following ...

**1**

vote

**1**answer

26 views

### Excel Visual Basic Issue

I've been using VBA quite a bit recently, and, so far, I haven't run into any issues. For some reason, and, I cannot for the life of me figure it out, visual basic wont include "+" or "-" signs in ...

**6**

votes

**4**answers

24k views

### Select an entire column minus header row in an Excel macro

How would I access a range that corresponds to an entire column starting at row 2 (there is a header row)?
The end of the selection should be the last non-empty cell in the column.

**0**

votes

**4**answers

7 views

### How to refer to cells in other sheets

I have a workbook contains several sheets. And i'm trying to use cell value that present in other sheet . How do i refer or use cell value in other sheet.

**0**

votes

**1**answer

35 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**0**

votes

**1**answer

34 views

### Excel - displaying numbers and text on cell

Hi I am struggling with a formula but not sure it can be done
In column F - I have number or text in each cell and I want to show in column G if its text to show blank and if a number show the actual ...

**0**

votes

**0**answers

33 views

### Coloring separate rows based on matching of data in key cell

i have a excel file as
i want change the sheet that after sort on key column(MasterID), any rows same as key column change color to similar.
for example

**-2**

votes

**2**answers

36 views

### identify the rows with the lowest values in an array based on identical values in a column of that array

I have an array of product data which includes code, description and cost. code is unique, cost is numeric and description is non-unique. Please see example. How can I select the cheapest of each ...

**1**

vote

**1**answer

26 views

### How to sum amounts in column given specific criteria in excel

I have a spreadsheet with two columns. A (for example) has the values 1 2 2 3 4 4 5 and B has 1.2 4.3 3 2 5 4.5 7.
How do I total the amounts in column B given that the cell to its left equals 2? In ...

**-1**

votes

**2**answers

38 views

### Search price Grid

I am looking for a way to find values within a table: Lets say I have width of 575 and a drop of 575 then the search values should round upward to 600 width x 600 drop and the answer should be 66.6.
...

**2**

votes

**0**answers

9 views

### Excel VBA not working when “enable editing”

I'm not sure if this is the right place to post this but I'm having issues with excel VBA. I sent a worksheet with custom VBA attached to an email. Once the user downloads the file, it open in excel ...

**-3**

votes

**1**answer

28 views

### Custom Data Validation in Excel 2010

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
...

**0**

votes

**1**answer

18 views

### I want to map rows from Sheet one on and excel file to other sheets if they meet certain criteria

I work in sales and cover a large territory. To manage the territory, I break it up into "Zones" (i.e. Philly / Pittsburgh / etc). My organization provides an excel file with every company I call on ...

**0**

votes

**1**answer

23 views

### How can I use indirect references for a pivot table's data source?

(This question is mostly about Excel, but it's also relevant for LibreOffice Calc, so I welcome answers about either.)
I have this sheet with many rows, some of which only become relevant at certain ...

**2**

votes

**2**answers

859 views

### How to disable keyboard shortcut animation in Office 2013?

I am looking for a way to disable the animations for keyboard shortcut selection in Office 2013, especially Excel 2013. When you select a keyboard shortcut using Alt and a key sequence (e.g. ...

**8**

votes

**2**answers

2k views

### How can I dismiss the floating “Auto Fill options” button in Excel 2010?

Reproduce the issue
Go to Excel and type fill in the first 2 rows of a column
Select both rows of the column
Drag down the anchor of the selection (bottom right) 1 row down
Now you will see this:
...

**1**

vote

**1**answer

45 views

### Excel: Calculate pilot currencies

I recently got my pilots license and started using Microsoft Excel as my backup logbook. Now I'd like to add a "currency-calculator", which should show me until when I am type and day/night current ...

**1**

vote

**1**answer

1k views

### How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example:
Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart.
Is it ...

**1**

vote

**0**answers

27 views

### How do I create a master workbook in excel?

In powerpoint we have something called a master slide. I want the same idea for excel. I want to create a template that I can work on with formulas and I want it to update all children files.
...

**0**

votes

**2**answers

2k views

### Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...

**0**

votes

**0**answers

10 views

### Editing registry for the error - One of your object libraries (I) is missing or damaged. Please run setup to install it

When I opened an excel (.XLS) file today, I got an error - One of your object libraries (I) is missing or damaged. Please run setup to install it. I don't know why that happened, but it could be ...

**2**

votes

**3**answers

9k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**0**

votes

**1**answer

14 views

### Adding a time period in Excel 2010

A simple question, but some quick Googling did not prove fruitful.
Basically, I have a column called "uniqueID", which is a unique identifier for all the people in my dataset. Most uniqueIDs have ...

**0**

votes

**2**answers

3 views

### Total number of instances of single-digit numbers w/in two-digit numbers w/in same cell.

Our legacy payroll system reports each day of the month, i.e., 1 through 31, across a single row of cells, e.g., A1:AE1. Below each day, an empty cell or a two-digit number is reported. An empty cell ...

**0**

votes

**1**answer

17 views

### display cells as improper fractions in excel?

In Excel one can format cells so that they display their numeric contents as fractions:
But the fractions are reduced, i.e. 3/2 is written 1 1/2. Is there a way to display improper fractions in ...

**-1**

votes

**1**answer

27 views

### how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...

**0**

votes

**1**answer

22 views

### Excel date time find max / min and max min timespan

I have data time data in excel in the format "04/18/2014 17:09:09". I would like to use MAX and MIN on a range of such dates to get max, min and time span between min-max.
I tried using custom format ...

**2**

votes

**3**answers

35 views

### Custom user function without using VBA

Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...

**0**

votes

**1**answer

6 views

### Load a picture from one inserted ActiveX Image to another - VBA Excel

I got a set of named pictures on an Excel sheet, created by the "Insert" button in development tag, and from the section "ActiveX controls" from the "Insert" button. What I want is, when I click on ...

**0**

votes

**1**answer

40 views

### How can I embed a tracking GIF in an Excel document?

I want to add www.sometrack.com/blah.gif to an Excel document. My goal is to embed a trackable element (e.g. a GIF). I want to send a person this document, and if they open it, the pixel opens ...