A
alfred.cloutier
I need a formula to find numbers in a column that are exactly within a
range, like a page range.
Example desired result:
Column A
7
10
100
Chapter 1 pp. 7-8: YES
Chapter 2 pp. 9-12: YES
Chapter 3 pp. 13-25: NO
Chapter 4 pp. 26-100: YES
As it is, I keep getting a YES for Chapter 3, with this formula:
=IF(AND(IF(COUNTIF(A1:A3,
">=13")>0,TRUE,FALSE),IF(COUNTIF(A1:A3,"<=25")>0,TRUE,FALSE))=TRUE,C1&",
","")
That's because the formula is finding that there is a number >=13
(100) and a number that is <=25 (10), yet none of these numbers is in
the page range of 13-25.
What function do I use to do this correctly?
range, like a page range.
Example desired result:
Column A
7
10
100
Chapter 1 pp. 7-8: YES
Chapter 2 pp. 9-12: YES
Chapter 3 pp. 13-25: NO
Chapter 4 pp. 26-100: YES
As it is, I keep getting a YES for Chapter 3, with this formula:
=IF(AND(IF(COUNTIF(A1:A3,
">=13")>0,TRUE,FALSE),IF(COUNTIF(A1:A3,"<=25")>0,TRUE,FALSE))=TRUE,C1&",
","")
That's because the formula is finding that there is a number >=13
(100) and a number that is <=25 (10), yet none of these numbers is in
the page range of 13-25.
What function do I use to do this correctly?