Hello,
I'm looking for 2 formulas or a macros that do the following. The first formula; In column D1 will give a date based on the data corresponding in the cell range if the name corresponds in column B and is within columns A1:A6. I'm not sure how to say find the date in column A and grab the data from corresponding cells in Column B however only up to the next date in column A.
The second formula is need is to place names in column E based on the date in column D
<tbody>
</tbody>
I'm looking for 2 formulas or a macros that do the following. The first formula; In column D1 will give a date based on the data corresponding in the cell range if the name corresponds in column B and is within columns A1:A6. I'm not sure how to say find the date in column A and grab the data from corresponding cells in Column B however only up to the next date in column A.
The second formula is need is to place names in column E based on the date in column D
a | b | c | d | e | f | g | h | |
1 | 8/4/2019 | John | ||||||
2 | ||||||||
3 | jacob | |||||||
4 | ||||||||
5 | Jill | |||||||
6 | john | |||||||
7 | 8/5/2019 | |||||||
8 | john | |||||||
9 | jacob | |||||||
10 | ||||||||
11 | jill | |||||||
12 | ||||||||
13 | 8/6/2019 | bill | ||||||
14 | joe | |||||||
15 | ||||||||
16 | 8/7/2019 | |||||||
17 | john |
<tbody>
</tbody>