Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Attn: Barb Reinhardt | Excel Programming | |||
Barb - don't worry, I got it working...you are a lifesaver!!!!!!.t | Excel Programming | |||
for Toppers and Barb | Excel Worksheet Functions | |||
Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
Ron Helped Once Can you do it again? | Excel Programming |