Hello,
I'm having an issue with a formula that I found on the MS page but I'm trying to change it
The formula is in cell "C2"
The original formula was =SMALL(array,COUNTIF(array,">"&K)+1)
I want to change "1" to cell "D2"
The reason is so the formula can start to count from where ever I tell it to start.
cell "D2" is a variable that I manually input
Thank you
I'm having an issue with a formula that I found on the MS page but I'm trying to change it
The formula is in cell "C2"
The original formula was =SMALL(array,COUNTIF(array,">"&K)+1)
I want to change "1" to cell "D2"
The reason is so the formula can start to count from where ever I tell it to start.
cell "D2" is a variable that I manually input
Thank you
Book1 | |||||
---|---|---|---|---|---|
B | C | D | |||
1 | 10:00:00 AM | 10 | |||
2 | #NUM! | 4:00:00 AM | |||
3 | 1 | 1:00:00 AM | |||
4 | 2 | 2:00:00 AM | |||
5 | 3 | 3:00:00 AM | |||
6 | 4 | 4:00:00 AM | |||
7 | 5 | 5:00:00 AM | |||
8 | 6 | 6:00:00 AM | |||
9 | 7 | 7:00:00 AM | |||
10 | 8 | 8:00:00 AM | |||
11 | 9 | 9:00:00 AM | |||
12 | 10 | 10:00:00 AM | |||
13 | 11 | 11:00:00 AM | |||
14 | 12 | 12:00:00 PM | |||
15 | 13 | 1:00:00 PM | |||
16 | 14 | 2:00:00 PM | |||
17 | 15 | 3:00:00 PM | |||
18 | 16 | 4:00:00 PM | |||
19 | 17 | 5:00:00 PM | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | C1 | =SMALL(C3:C19,D1) |
C2 | C2 | =SMALL(C3:C19,COUNTIF(C3:C19,">"&D1)+D2) |