Hi,
If I have the following data:
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
And I use vlookup, I want the data for all of the days that have data (3 data points).
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
Please help me get what I want highlighted in red.
Thank You
If I have the following data:
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | 1/1/2004 | 5 | ||
| 2 | 6 | |||
| 3 | 7 | |||
| 4 | 1/2/2004 | 3 | ||
| 5 | 4 | |||
| 6 | 5 | |||
| 7 | 1/7/2004 | 10 | ||
| 8 | 9 | |||
| 9 | 8 | |||
Sheet1 | ||||
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
And I use vlookup, I want the data for all of the days that have data (3 data points).
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| F | G | H | I | J | |||
| 1 | 1/1/2004 | 5 | 5 | ||||
| 2 | #N/A | 6 | |||||
| 3 | #N/A | 7 | |||||
| 4 | 1/2/2004 | 3 | 3 | ||||
| 5 | #N/A | 4 | |||||
| 6 | #N/A | 5 | |||||
| 7 | 1/3/2004 | #N/A | |||||
| 8 | #N/A | ||||||
| 9 | #N/A | ---> what I want | |||||
| 10 | 1/4/2004 | #N/A | |||||
| 11 | #N/A | ||||||
| 12 | #N/A | ||||||
| 13 | 1/5/2004 | #N/A | |||||
| 14 | #N/A | ||||||
| 15 | #N/A | ||||||
| 16 | 1/6/2004 | #N/A | |||||
| 17 | #N/A | ||||||
| 18 | #N/A | ||||||
| 19 | 1/7/2004 | 10 | 10 | ||||
| 20 | #N/A | 9 | |||||
| 21 | #N/A | 8 | |||||
| 22 | 1/8/2004 | #N/A | |||||
Sheet1 | |||||||
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>
Please help me get what I want highlighted in red.
Thank You
