barry houdini questions

barry houdini answers

• Count if date range fits within other date range
• Formula to find the header index of the first non blank cell of a range in Excel?
• Show the column header to a row if there is value in cells of that columns without VBA
• Find the number of a row that contains two specific values?
• Excel: Multiply each cell in row X by corresponding cell in row 2, and get sum
• How to rank within category in Excel?
• Find the last number in a text string
• Return all characters but the first X amount Excel 2007
• Sum of certain letters occurrences in alphanumeric string using Excel
• Multiple Column vs Multiple Column Lookup