| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Help with series data
How about a "one-shot" deal?
Enter this in A1 and copy down: ="TOTE"&20000+INT((ROW()-1)/4) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lester Mosley" wrote in message ups.com... Thanks.. I did find another method from a co-worker.. A1 would have the root 20000, a2 would have =A1+.25 then b1 would have ="TOTE"&int(a2) It works.. have it drop off the decimal. copy/paste special. a few extra steps but we got there. Thanks for your help though |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| QUESTION- Simpler Way to Add a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
| HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
