barry houdini questions

barry houdini answers

• Excel Summing Formula setting against month date using SUMPRODUCT
• How to count unique/ distinct visible values in a filtered column, with considering blank cells?
• How can I count only unique occurrences of a value from table using multiple criteria?
• MS Excel Value Range Equivalent (IF Statement)
• Excel date/time difference
• Excel: Search column for specified value, return value in same row different column
• Rounding up different numbers in Excel
• How to use INDEX when applying an IF and not a MATCH?
• SUMIF(S) with VLOOKUP
• Extracting digits from a cell with varying char length