Sam questions

• Grouping by all columns except one to count distinct values on the remaining column
• VBA Arrays - Check strict (not approximative) match
• populate combobox in VBA with array elements
• COUNTIF with multiple criteria
• Java Packages - refer to a class from a different package
• VBA Unfilter range
• Ref workbook by path and name - VBA
• Method Select of Object '_Worksheet' failed - why?
• Cumulating value of current row + sum of previous rows
• NULL values are excluded. Why?

Sam answers