Questions tagged [excel-2016]

The Excel-2016 tag is used for referencing the spreadsheet component of the Microsoft Office 2016 suite released 22 Sep 2015. The version independent Tag is "excel". If it is about VBA code or an Excel formula or worksheet function, then tag it vba & excel or excel-formula or worksheet-function respectively.

Excel 2016 is the spreadsheet component of the Office 2016 suite released on 22 Sep 2015. It incorporates what was previously the Power Query add-in, additional charting options and Power BI Desktop. details here

From Wikipedia Included in the Microsoft Office 2016 package, along with a lot of new tools included in this release:

  • Power Query integration
  • Read-only mode for Excel
  • Keyboard access for Pivot Tables and Slicers in Excel
  • New Chart Types (Sunburst, Waterfall, Pareto Charts, 3D Data Map etc.)
  • Quick data linking in Visio
  • Excel forecasting functions
  • Support for multi-selection of Slicer items using touch
  • Time grouping and Pivot Chart Drill Down
  • Excel data cards
  • The 'Tell Me' box to search inbuilt functions and operations

For Apple Macintosh Excel 15.0 forms part of the "Office 2016" suite.

Office 2016 for Mac brings the Mac version much closer to parity with its Windows cousin, harmonising many of the reporting and high-level developer functions, while bringing the ribbon and styling into line with its PC counterpart.

For a poignant article on this see Walt Mossberg's article Office for Mac Is Finally a 'First-Class Citizen'.

Links:

1509 questions
-2
votes
4 answers

Regex remove english text from mixed chinese-english sentences using Notepad++ and Excel?

I work with Notepad++ and Excel. I have data that contains text in English and Chinese. The data structure is as follows:

chinese text

english text

chinese text

english text

chinese text

english…

elevaku
  • 7
  • 2
-2
votes
1 answer

Populate a table from a list using multiple criteria

I need to populate a table using 2 criteria to match the information. the source data is A B C Month Segment Value 01/08/18 Alfa 236.200 01/08/18 Bravo 39.700 01/09/18 Alfa 8.400 …
rzb1
  • 41
  • 7
-2
votes
1 answer

Concatenate only existing data

I'm trying to concatenate 4 columns, out of which two columns always are constant, but other two columns has to be concatenated only if thre is data inside. for EX: ** Column1 Column2 Column3 Column4 Result -------------------------------------- 1 …
venky ps
  • 25
  • 1
  • 5
-2
votes
1 answer

How to assemble Offset function with Condition?

I Have date data in Column A and values data in Column B. My aim goal is that for each date in column A : look if one value (column B) during 1 year is less than 90% of the corresponding Value of the date. This is my data: Output example : I…
Bitoku
  • 23
  • 5
-2
votes
1 answer

Need help combining and adding strings in Excel

I have a list of items in one column and a total number in another column. I need to combine every instance an item appears in column A and the amounts in column B. I also need it to sort by highest number first on its own if possible. Here is an…
Paul D
  • 1
-2
votes
2 answers

How to evaluate a formula in Excel cell

I have an excel file which has some multiplication (not the result but the formula) How can I find the result of each, if even possible? Excel: 5*10 5*3*1 10 20*3*2 Expected output: 50 15 10 120 Here is what I tried: =MID(A1; 1; FIND("*"; A1) - 1)…
sertsedat
  • 3,490
  • 1
  • 25
  • 45
-2
votes
1 answer

Importing Multiple Txt files using macro

I had previously asked this question in this post: Importing multiple text files using VBA Macro After a while, i created an entire new workbook and when i try to copy/paste this code to a macro module, i get a compile error: user-defined type not…
Dani
  • 1
  • 1
  • 3
-2
votes
1 answer

How do you copy a worksheet as an Image and paste it into a specific cell?

The Situation - I'm designing a method to pass down information from shift to shift. It needs to be rigid enough to stay standardized but flexible enough that people can explain the myriad situations that occur. My idea is that they fill out their…
-2
votes
1 answer

Assign values from attributes to names in Excel

This is the table to show how the names are written in the fort column. I need to identify the column/attribute's values (the 5 values in italics) and assign it to that name. I made a command-click button named Values that I want to output the name…
Michael
  • 11
  • 1
-2
votes
1 answer

excel16: vba, how choose date dd/mm/yyyy from combo box and update cells

Pls help... In excel V16 forms, I've added combo boxes for date of entry & date of last payment set as DD / MM / YYYY defaulted with values: DD (01 to 31)/ MM (01 to 12)/ YYYY (2000 to 2020) User can input a studentID and click on search its…
Akika.YS
  • 17
  • 5
-2
votes
3 answers

How to count occurrence of each sentence in Excel in this specific case?

The challenge here is the sentence is not split by cell. They are in the same column, but they might appear in the same cell. One sentence per line. I need to count the occurrence of each sentence, for example, occurrence of "The cat is pink" is 2…
Ice s. Woo
  • 27
  • 8
-2
votes
1 answer

How to make a value based reference in Excel

I have an excel sheet which fetches the values from an API and these values changes in real time, I mean the row position changes on daily basis. Problem is when I reference a particular row to write a formula in another sheet and its value changes…
-2
votes
4 answers

Spliting 2 Words in Excel before the last capital Letter?

I am trying to figure out how to split a single word into 2 separate words in excel. e.g. input word: BTCBitcoin Desired output: BTC Bitcoin any suggestions? Thanks.
-2
votes
2 answers

How to autofill values in excel based on the cells above and below

good people, I have a table full of unique id's (as mentioned below) but there are missing values for few id's. I want a formula/code to fill in the blanks based on the values above and below of any cell. For example: here there are two empty rows…
-2
votes
2 answers

Print Button In Excel 2016 Using Macros?

I'm currently trying to create a Print Button on one of my worksheets. I need it to print that worksheet as well as another one. Both of the names are "Budget Sheet" and "Listed Commitments Sheet" without the quotation marks. I created the…
Ash
  • 47
  • 8
1 2 3
99
100