There are two columns with cells.

A1: A100 - numbers from 1 to 100

B1: B100 - text data

It is necessary to get to the list the data of cells B1: B100 where A1: A100> = 20 and A1: A100 <= 50

I can not understand what function (s) this can be done, namely, to set two conditions for one range of cells

  • one
    Using the function sheet And (), combine the two conditions into one ... - Akina
  • In this example, everything works IF (AND (A6> = 20; A6 <= 50); A6), here the immediately indicated cell with a suitable condition, BUT, as soon as I specify not the cells but their ranges, it always gives 0: IF ( AND (A1: A100> = 20; A1: A100 <= 50); B1: B100) - webstackoverload
  • Well, such a thing should be entered as an array formula ... How did you enter it? And in general, it is not very clear what is required ... in particular, it is unclear what kind of conclusion and exactly where you are expecting. - Akina
  • As it is not clear, everything is quite simple, the fact is that it is not easy to understand how to make two conditions for one band. For example, to make it clearer, I will give an example with one condition and the formula that works, click on the cell, then data> validity> range cell, insert the IF formula (A1: A100> 20; B1: B100), after which the results of the texts appear in the cell cell is less than 20. - webstackoverload 1:32 pm
  • It is strange that no one can solve the problem where only two conditions are needed, to be even clearer, the search for the number goes on like in the function between - webstackoverload 4:34 pm

0