barry houdini questions

barry houdini answers

• 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
• LINEST gives #VALUE! error for some data
• SUMIF dynamically change summing column
• Unique values in excel with multiple columns
• How to use arithmetic operators to get cell location
• Excel index match multiple row results