barry houdini questions

barry houdini answers

• Cannot implement INDIRECT() within an array formula
• Excel formula LIKE, AND, IF, WILDCARDS
• Round Excel Time Difference to Next 15 Minute Interval
• Combine two data ranges into one range (Google Drive Excel)
• How to concatenate date in Excel 2010
• Multiple conditions in Excel conditional formatting
• week number and year combination
• Using DateTime when referencing a cell with SUMIFS()
• Excel - Date Range includes given time of day (a better approach)
• Sorting ranked data in Excel while listing duplicates as different whole numbers