xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
Using excel 2016 I have dates in columns A and C and values in columns B and D.
The datesand their corresponding values are not matched but I only want to compare the values in B and D with their correspoding dates. Is there a formula I can put in the adjacent columns to match the dates with one another? I need the dates and values to match to do an accurate comparison om my chart..
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
The datesand their corresponding values are not matched but I only want to compare the values in B and D with their correspoding dates. Is there a formula I can put in the adjacent columns to match the dates with one another? I need the dates and values to match to do an accurate comparison om my chart..
Thursday, October 9, 1980 | 1.1763 | Thursday, October 9, 1980 | 85.64 |
Friday, October 10, 1980 | 1.1765 | Friday, October 10, 1980 | 85.59 |
Monday, October 13, 1980 | 1.1777 | Tuesday, October 14, 1980 | 85.73 |
Tuesday, October 14, 1980 | 1.1774 | Wednesday, October 15, 1980 | 86 |
Wednesday, October 15, 1980 | 1.1767 | Thursday, October 16, 1980 | 86.09 |
Thursday, October 16, 1980 | 1.1756 | Friday, October 17, 1980 | 86.52 |
Friday, October 17, 1980 | 1.1755 | Monday, October 20, 1980 | 86.98 |
Monday, October 20, 1980 | 1.1754 | Tuesday, October 21, 1980 | 86.92 |
Tuesday, October 21, 1980 | 1.1754 | Wednesday, October 22, 1980 | 87.06 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>