Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Barb...you helped & said come back

Barb...
Works great!
Now here's what this looks like & a question.
abc D E F G H
I
1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
2
3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09

Question: we will have about 200 entries. Do I have to manually enter the
formulas changing D progressively each time. That would be 5 formulas across
for each line (entry/person)

Then, we can address how to pull information and sort.
Thanks,
David
--
David
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default Barb...you helped & said come back

No just enter them in row 2, select D2:H2, move the cursor to the bottom
tight hand cell until it changes to a black cross, then just drag the
formula down.

--
__________________________________
HTH

Bob

"caseysmydog" wrote in message
...
Barb...
Works great!
Now here's what this looks like & a question.
abc D E F G H
I
1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
2
3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09

Question: we will have about 200 entries. Do I have to manually enter the
formulas changing D progressively each time. That would be 5 formulas
across
for each line (entry/person)

Then, we can address how to pull information and sort.
Thanks,
David
--
David



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Barb...you helped & said come back

I saw your replly, but this is the first I've had time to come back. I just
answered your message in the other thread and I see Bob has answered it here.


Barb Reinhardt

"caseysmydog" wrote:

Barb...
Works great!
Now here's what this looks like & a question.
abc D E F G H
I
1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
2
3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09

Question: we will have about 200 entries. Do I have to manually enter the
formulas changing D progressively each time. That would be 5 formulas across
for each line (entry/person)

Then, we can address how to pull information and sort.
Thanks,
David
--
David

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attn: Barb Reinhardt Looping through Excel Programming 0 January 3rd 08 03:51 PM
Barb - don't worry, I got it working...you are a lifesaver!!!!!!.t James T Excel Programming 1 August 24th 07 03:06 AM
for Toppers and Barb yodochi Excel Worksheet Functions 3 July 25th 07 12:57 PM
Barb Reinhardt: HOW TO: Plot a Team Name .... Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM
Ron Helped Once Can you do it again? Hambone Excel Programming 2 February 19th 04 08:51 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"