column – International Business Consulting

SAP find out which views are open for a material / article : List of Material Master views in MM03

SAP find out which views are open for a material / article

June 24, 2017June 21, 2017 ybierling 1 Comment Accounting, article, column, Costing, Forecasting, maintenance, MARC, material, Material Master, Materials Management, MM03, MRP, MSTA, PSTAT, purchasing, sales, SAP, SAP MM, SE16N, storage, table, transaction

Want to know which views are open in Material Master MM03 transaction for a material, and for which organization(s) :

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with functions in Excel

January 29, 2017January 18, 2017 ybierling 0 Comments builtin, column, count, countif, easy, en, Excel, function, list, MSOffice, option, row, sheet, simple, table, unique, value, values

Having a list of values, for example city names, and want to know how many times each unique entry is

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with a pivot table in Excel

January 28, 2017September 10, 2018 ybierling 0 Comments column, count, en, Excel, list, MSOffice, option, pivot, row, sheet, table, unique, values, various

Having a list of values, for example city names, and want to know how many times each unique entry is

How to combine two data sets and create all possible combinations with Excel : Result of combination of two data sets by creating some ID columns, and applying some vlookups

How to combine two data sets and create all possible combinations with Excel

January 15, 2017July 4, 2017 ybierling 0 Comments automatic, cell, column, combine, customer, data, en, Excel, expand, file, function, line, list, merge, Microsoft, MSOffice, product, roundup, sheet, spreadsheet, various, vlookup

Having two different data sets, for example a customers list and a products list, and want to combine them to

Microsoft Excel paste CSV into cells : Select CSV data column

Microsoft Excel 2013 paste CSV in spreadsheet

October 1, 2016November 18, 2016 ybierling 0 Comments column, comma, csv, data, delimited, en, Excel, Microsoft, paste, selection, sheet, spreadsheet, transform, values

Copy pasting CSV (Comma Separated Values) is pretty easy in Excel 2013 ! In short : use the Data >