XOR LX questions

XOR LX answers

• Use INDEX MATCH to find greater than/equal to value
• BUG in Excel CountIF function
• Unexpected COUNTIF behavior when mixing number and text (EXCEL)
• excel match value(get row) in two-dimensional array
• Excel: Check if cell contains number in text string
• Use of INDEX MATCH to find absolute closest value
• Sum values from multiple rows using vlookup or index/match functions
• Excel: Perform a SUMIF where the criteria is a comma-delimited list