Tom? Chuck? Additional question...

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

O.K... You showed me how to duplicate the date. Can you
show me how to duplicate the date AND a value that is
attached?

From this:
10/1/2001 23.1
10/2/2001 22.4
10/3/2001 21.5
10/4/2001 21.0
10/5/2001 20.6
10/6/2001 20.7
10/7/2001 20.7
10/8/2001 20.7
10/9/2001 21.2
10/10/2001 21.8
10/11/2001 49.1
10/12/2001 58.8

To this:
10/1/2001 23.1
10/1/2001 23.1
10/2/2001 22.4
10/2/2001 22.4
10/3/2001 21.5
10/3/2001 21.5
10/4/2001 21.0
10/4/2001 21.0
 
Set up your existing table that you show here with your dates and
corresponding values as a VLOOKUP table........(INsert > Name > Define, and
call it DateTable),,,,,then go ahead and create your doubledate list as I
described in my earlier post or any other way you want to do it......say
that doubledate list is in column A.........then in B1 put this formula, and
copy it down column B as far as you have dates in column A......

=VLOOKUP(A5,DateTable,2,TRUE)

The formulas will look up the dates from the column A cells in the lookup
table and place the corresponding values in the cells in column B.....

Vaya con Dios,
Chuck, CABGx3
 
Yeah, what's happening is you're probably using the same exact formula (with
the RangeName "DateTable") on your second sheet in that workbook and when
you create a RangeName in Excel, it's good for the whole workbook, so it's
working properly......so, on the second sheet of that workbook, you need to
name the second DateTable to something else, like SecondDateTable, and use
that RangeName in the formulas on that second sheet......etc etc for any
other sheets in that same workbook that you might want to do the same
thing......if you open another entire new workbook, those RangeNames
shouldn't carry over.........

Vaya con Dios,
Chuck, CABGx3
 
You're welcome Deb, glad you got it working........and keep coming back.
Indeed, these newsgroups are really really great for getting answers, and
for keeping your own skills honed by helping others........Usually, a
single post will return several different answers from which you can pick
and choose the one you're most comfortable with.......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top