Searching in dynamic data set for data

S

segran

Active Member
Joined
Aug 20, 2004
Messages
335
Hi,

I sincerely hope someone can help me solve a major dilemma.

I have non-continuous data for a year. For example,each day has 3 data points:

A B C

1/1/2011 Saturday 10
20
30
6/1/2011 Thursday 5
8
9
17/1/2011 Monday 13
18
23

..

I have non-continuous data for the year, and I need to fill in data for the days missing in between. I need to find the closest data in the dataset I have to complete this. For example, 2/1/2011, is a Sunday, so I must find the closest Sunday in the dataset, and automatically fill in the data. For example, 8/1/2011 is a Sunday, which is like 1/1/2011, so the 1/1/2011 can be used.

Please can you give me a formula or a macro to do this.

Thank you in advance.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
<html><head><title>Excel Jeanie HTML</title></head><body>

<!-- ######### Start Created Html Code To Copy ########## -->

Excel Workbook
ABC
11/1/2011Saturday10
220
330
46/1/2011Thursday5
58
69
717/1/2011 Monday13
818
923
Sheet1




<!-- ######### End Created Html Code To Copy ########## -->

</body></html>
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Excel Workdays Formula (Specific)
Replies
7
Views
410
felixstraube
F
L
  • Solved
=unique(vstack in a table
Replies
6
Views
448
Vogateer
V
S
  • Solved
NETWORKDAYS.INTL
Replies
7
Views
120
Fluff
Fluff
T
  • Question Question
Conditional Formating Current Week??
Replies
3
Views
192
MARK858
MARK858
D
  • Solved
Is there a quick way to create / fill this list
2 3
Replies
20
Views
415
Eric W
Eric W

Forum statistics

Threads
1,224,509
Messages
6,179,192
Members
452,893
Latest member
denay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top