westend9876
Member
In column A1 - A6 I have numbers like:
3.75
7
9
2.35
5
11
Columns
B1-B4 & C1-C4
1 4
5 8.5
9 10
11 14
Column D should return the row number that each number in column A falls between in columns B - C
Answers
D1 = 1
D2 = 2
D3 = 3
D4 = 1
D5 = 2
D6 = 4
3.75
7
9
2.35
5
11
Columns
B1-B4 & C1-C4
1 4
5 8.5
9 10
11 14
Column D should return the row number that each number in column A falls between in columns B - C
Answers
D1 = 1
D2 = 2
D3 = 3
D4 = 1
D5 = 2
D6 = 4