Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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,T RUE,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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confused about range names | Excel Discussion (Misc queries) | |||
Big background page numbers/ Can't change format of a range | New Users to Excel | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
Excel Page Range Printing Problems | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |