XOR LX questions

XOR LX answers

• Excel counts the number of times a value appears in a group of columns but counts only one instance of the name per row
• SUMIF to sum cells only if other corresponding cells contain a number
• Using Excel N function with arrays
• 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