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 |
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...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