, as shown in the figure I have A work table, A column is A numerical value, B column is the name, select A column value required to exploit the formula only 10 and 11 people's name, in the sample pictures, only xiao Ming and XiaoHong is eligible, zhang SAN no 11, and the number 9,14,15; Although bill has numerical 10, 11, but more the number 9, could you tell me how to write the formula, thank you.

CodePudding user response:

Do not recommend using EXCEL implementation, it is suggested that the import of data to a database, and then to implement SQL query conditions can be very simple!

CodePudding user response:

With an auxiliary column, the IF function, every accords with a condition of 0, is not in conformity with the conditions of 1, then SUMIF names summation, 0 is eligible
=the if (or (A2=10, A2=11), 0, 1)