BeginCodingNow.com

for data analysts & software developers

Daily Archives: February 12, 2023

Excel Filtering
This post is about filtering in Excel. For information on the FILTER function have a look at our […]

February 12, 2023 in Excel tagged location / copy / select / filter / advanced by Mike

Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]

February 12, 2023 in Excel tagged function / dynamic / sort / arrays by Mike

Excel Dynamic Arrays

What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […]

February 12, 2023 in Excel tagged array / dynamic / formula / spill by Mike

Excel’s Hash Reference

What is the hash symbol that you see in some formulas? What does it do? If you have […]

February 12, 2023 in Excel tagged hash / excel / spill by Mike

Sorted Data Validation List
In Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […]

February 12, 2023 in Excel tagged data / list / array / validation / dynamic / sort by Mike