All Questions
Tagged with microsoft-excel-2016 macos
19
questions
0
votes
2
answers
82
views
Excel - Combining multiple cells in a single row
I have data disposed in this manner:
Jonh Seedman New York, New York 01/01/1900
5th Ave +1 NXX-NXX-XXXX
Homer Simpson Springfield, Illinois....
- 3
1
vote
2
answers
2k
views
SUMPRODUCT + INDIRECT reference, How to make it work if i'm adding rows?
I have a question/problem, I have an excel formula that looks something like this
=(SUMPRODUCT(((INDIRECT("'"&G9&"'!"&$A$9)=$I$6)*(INDIRECT("'"&G9&"'!"&$B$9)))))/1.16
It is ...
0
votes
1
answer
1k
views
Is there a way to match two time series covering same period but with different days missing?
I have two time series for interest rates. Both are daily, but one includes only trading days while the other includes every calendar day. I would like to match these series in adjacent columns to ...
- 3
1
vote
0
answers
59
views
How to use the native macOS file dialog in excel 2016?
I despise excel 2016's custom file dialog, and I never want to have to use or see this:
Is there a way to tell excel to instead use the native file Open/Save dialog of macOS?
- 472
0
votes
1
answer
227
views
Strange behaviour with space in front of number value on Excel 2016 macOS
I encountered some strange behaviour in my excel 2016 on macOS High Sierra.
I opened fresh new workbook, then I typed " 1.5" (I typed space then 1.5), then wrote this formula on A2 =TRIM(A1), then on ...
- 101
3
votes
6
answers
29k
views
Can I change the default currency symbol in Excel 2016 for a single workbook
I'm using Excel 2016 on MacOS High Sierra. I'm based in the UK, and so my global default currency symbol is £. I'm creating a new workbook with forecasts for a European operation, so in that workbook ...
- 4,463
3
votes
1
answer
750
views
Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38
I am trying to create named references that have a Worksheet scope in Microsoft Excel for Mac V15.38.
I want to set up a template sheet that gets duplicated multiple times (example: a template sheet ...
- 580
1
vote
3
answers
135
views
Excel Complicated Sort
I am trying to sort several thousand rows of weather data. Each row represents a date (col. C, DATE) and the only other column I am concerned with is the precipitation level (col. D, PRCP.)
My goal ...
- 11
0
votes
1
answer
65
views
Changing number format based on value, within one cell
I have an Excel 2016 table that lists weights in pounds. For entries that are 2000 pounds or greater, I want to convert to tons and add a "tons" suffix. So the data:
500 1000 2000 3000
Would ...
- 101
0
votes
2
answers
1k
views
Show data from one sheet into another (Excel 15, Mac)
I have a sheet (let's call it 'A') with quite some data from B1 to AAA1, and from A2 to A9999.
I'd like to be able to show that data in another sheet ('B'), at the same location each cell has in 'A', ...
- 137
0
votes
0
answers
29
views
OSX Sierra 10.12.1, Excel 2016: Cleaning Excel data after converting from PDF
I needed to compile data from a PDF into an Excel spreadsheet for further analysis. Each PDF page begins with "Unclassified" at the top and a row with the column headings. I used NitroPDF for the ...
- 1
-1
votes
1
answer
253
views
Excel 2016 for Mac - converting a matrix to list
I've already seen some answers here but none work on Excel 2016 for Mac.
I want a simple solution to convert a matrix to a list like this:
date city1 city2 cityN
jan1 value value value
...
4
votes
1
answer
2k
views
Why is my Excel chart grouping all my x-axis time values at 0:00?
I am using Excel 2016 for Mac to produce a time-based chart to record two temperature. One column for the date and time, two more for temperature readings. However, Excel appears to be ignoring the ...
- 494
-3
votes
2
answers
81
views
Pull out matches with formula
I am trying to compare two columns and pull out the data is the same? I have tried multiple formulas but unable to produce multiple data? I am using 2016 Excel for Mac.
Sample info:
I have tried ...
- 1
0
votes
1
answer
615
views
Make an excel chart based on a pivot table, with multiple years
I've had this problem for some time. Using Mac, Excel v15, 2016.
As you can see, I have 2015 and 2016 (ignore the months showing as Jan-15, think of them as just month names; I tried editing that by ...
- 45
0
votes
2
answers
4k
views
Hide a Control Box in Excel
I have some radio buttons in Excel (2011 Mac), and they are grouped by a Group Box.
I want to make the Group Box invisible. I searched on the internet and found that I could do that with VBA by ...
- 195
0
votes
1
answer
97
views
How to delete one of each set of duplicate values in Excel?
I have a spreadsheet that contains many duplicates. Instead of removing all of the duplicates, I would like to remove one of each duplicate. I want to remove one record from each set of duplicates.
...
12
votes
3
answers
18k
views
How to disable snap/jump scrolling in Excel 2016 for Mac
I'm desparately looking for a way to disable snap-scrolling in Excel 2016 for Mac. Basically as you scroll Excel will continually try to keep the cell you're focused on in the centered. So when you're ...
- 121
8
votes
2
answers
13k
views
How to create custom shortcuts in Excel 2016 for mac
I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. being able to create new shortcuts for ...
- 183