ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Barb...you helped & said come back (https://www.excelbanter.com/excel-programming/419578-barb-you-helped-said-come-back.html)

caseysmydog

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

Bob Phillips[_3_]

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




Barb Reinhardt

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



All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com