The 2016 version of Microsoft's spreadsheet application. Unlike previous versions, this Office Suite is cross-platform, working on both Windows and OSX. Because of this, when using this tag, it may be applicable to also tag your question with the Operating System you're on.

**1**

vote

**1**answer

42 views

### Using a scroll bar to control pivot table filters

I have created a bar chart using a pivot table. The table has two filters in it to choose with row I am pulling data from. Currently, I can use a drop down menu to change these filters.But, I would ...

**0**

votes

**0**answers

25 views

### Filter based on 3rd character of a cell

I have list of data exported from Microsoft Dynamics AX 2009 into sheet1. I would like to filter those items based on the value of J2:Jxx. But it is dependent on the 3rd character of J2:Jxx.Example...

**0**

votes

**0**answers

6 views

### Unhide specific rows based on value of two cells

I'm trying to Unhide rows 20:30 in my sheet given two parameters: dropdown in Cell A10="yes" or "no" and a dropdown in cell B10 that has values of 1-10. Example, if A10="no", then no rows ...

**0**

votes

**1**answer

36 views

### How to sort duplicate rows of values into unique rows and multiple columns

Say I have a sample table like this:And I want to make it like this:Basically, it is making values in column A unique by moving all duplicate values of each unique row into the next column over. ...

**0**

votes

**0**answers

12 views

### I want to extract specific rows of data. How do I do this?

I have multiple rows of data for the same individual. I want to be able to extract a specific row for each individual. How do I do this?GROUP Animal ID Litter # Sow ID Sow Parity Gender ...

**0**

votes

**1**answer

51 views

### Calculate price increment in excel [on hold]

I am trying to calculate price increment between two prices for a given budget in excel.For example:C4 Total order size (TOS)=$3000 <- this is the MAX amount I want to spend but NOT all at ...

**1**

vote

**1**answer

18 views

### Changing the interval values on line chart x-axis

I'm plotting two functions onto a line chart, and I need to change the values on the x-axis. The graph is linked at the end of the question, along with the table that the values are sourced from....

**0**

votes

**0**answers

8 views

### Excel 2016 creating a master workbook

I am working on a workbook that has multiply spreadsheets. The first spreadsheet is always the same format but different information(clients). The second spreadsheet pulls information from the 1st ...

**0**

votes

**0**answers

20 views

### Excel: Connecting to an online HTML table missing the <table> tag

I'm working in Excel 2016. My organization switched the location where it publishes a table for a report, and I have been tasked with redirecting the connection on a spreadsheet. I'm not an Excel ...

**0**

votes

**0**answers

48 views

### Close and restart excel at arbitrary point in running a macro?

Suppose there is a marcro example_code in a excel 2016 file: example_excel.xlsm which has a lot of code but does not create external files (all the calculations are performed inexample_excel.xlsm.I ...

**0**

votes

**0**answers

7 views

### How do I remove a HYPERLINK() formula that assigns a URL to a link name, and keep the URL assigned to the link name?

I have 3 columns, 'C' is a list of URLs, 'E' is a list of friendly names I use to represent the URL, and 'D' is the link.To make the Link names into hyperlinks, I created this formula for the link ...

**1**

vote

**1**answer

15 views

### excel 2016 exchange value automatically to=“*value*” in other cell

I have to exchange value in one cell to="\*value\*"That is the only way that I found to make=countif and=sumif formula work.At the moment the only solution that I found is to type="**" ...

**1**

vote

**1**answer

32 views

### Excel - how to create new column at empty cell

I have been sent an Excel file of an export table of our contacts. However, all details have been exported into a single column:ExampleUser 1User 1 TitleAddressUser 1 IDUser 2User 2 Title...

**1**

vote

**1**answer

40 views

### **Text to Columns** for binary code in Excel

I am trying to do the Text to clumns command for columns where the cells look like this: 10000010011> 10101010101>01100111000> 101101010110> is used to split the data into 4 columns....

**1**

vote

**1**answer

16 views

### How to copy in Excel 2016 a cell with hyperlink from one sheet to another using formula?

I am automating an excel based report and need a formula that will take cell A2 with its hyperlink from Sheet2 and copy it to another column in Sheet 1. Hyperlink points to external web address. When ...