A B C D 46.14 0 46.18 46.23 46.15 1 46.16 0 46.17 0 46.18 0 46.19 0 46.20 0 46.21 1 46.22 0 46.23 0 46.24 1
Using the above table, I'm looking for some formula that can tell me if "1" exists in column B, for the specified range in Columns C and D. Thus I want it to scan column B only for the rows between 46.18 and 46.23.
This is recurring through my spreadsheet, which is much larger than what is shown. My main issue is just setting it up so it looks through column B between the values in C and D rather than just stopping at the first "1" or counting every single "1". Thanks in advance! Sorry if I did not explain it well.
Bookmarks