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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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 ...

153050per page