Hello,
Could I please have some excel help.
I'm looking for a formula to go into column H, I and J
Column H Formula: The formula I need to go into column H is using target numbers from Column F and G, use those target numbers to search Column D from top to bottom and whichever number is matched first (or if the "Target Higher" is matched first the number can go over or "Target Low: matched number can go lower)
Coumn I and J should be the time and date for the matched number.
For example purposes I've manually entered the results into the grey section (column H, I and J) to display what should be there if I can get a formula working.
[
Could I please have some excel help.
I'm looking for a formula to go into column H, I and J
Column H Formula: The formula I need to go into column H is using target numbers from Column F and G, use those target numbers to search Column D from top to bottom and whichever number is matched first (or if the "Target Higher" is matched first the number can go over or "Target Low: matched number can go lower)
Coumn I and J should be the time and date for the matched number.
For example purposes I've manually entered the results into the grey section (column H, I and J) to display what should be there if I can get a formula working.
[
mrexcel.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Name | Date | Time | Number | Name | Target High | Target Low | Target Reached | Target Date | Target Time | ||
2 | Steve | 1/01/2024 | 10:00:00 AM | 1 | Steve | 2.9 | 1 | 3 | 2/01/2024 | 10:00:00 AM | ||
3 | Steve | 1/01/2024 | 1:30:00 PM | 2 | John | 32 | 24.8 | 23 | 1/01/2024 | 1:30:00 PM | ||
4 | Steve | 1/01/2024 | 2:00:00 PM | 1 | ||||||||
5 | Steve | 2/01/2024 | 10:00:00 AM | 3 | ||||||||
6 | Steve | 2/01/2024 | 1:30:00 PM | 4 | ||||||||
7 | Steve | 2/01/2024 | 2:00:00 PM | 5 | ||||||||
8 | Steve | 3/01/2024 | 10:00:00 AM | 3 | ||||||||
9 | Steve | 3/01/2024 | 1:30:00 PM | 2 | ||||||||
10 | Steve | 3/01/2024 | 2:00:00 PM | 1 | ||||||||
11 | John | 1/01/2024 | 10:00:00 AM | 30 | ||||||||
12 | John | 1/01/2024 | 1:30:00 PM | 23 | ||||||||
13 | John | 1/01/2024 | 2:00:00 PM | 27 | ||||||||
14 | John | 2/01/2024 | 10:00:00 AM | 22 | ||||||||
15 | John | 2/01/2024 | 1:30:00 PM | 16 | ||||||||
16 | John | 2/01/2024 | 2:00:00 PM | 19 | ||||||||
17 | John | 3/01/2024 | 10:00:00 AM | 22 | ||||||||
18 | John | 3/01/2024 | 1:30:00 PM | 21 | ||||||||
19 | John | 3/01/2024 | 2:00:00 PM | 27 | ||||||||
Data |