barry houdini questions

barry houdini answers

• Extracting digits from a cell with varying char length
• Custom number format in Excel
• Listing top 5 items from a table in Excel
• Excel - find last value in a column which is not an error or blank
• Excel formula: count of unique cells in column, IF corresponding row is certain value
• Variable length series
• How to count number of "Yes" in column C once only if ID in column B repeats
• Excel Formula: Count cells where value is date
• Excel: Sum a range of cells if a related key is in a range of values using a formula
• Excel RANDBETWEEN as a string