Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data from range to rows
Correct - Once the phase value is zero, the next phase begins (btw, nicely illustrated!) and yes, I have them running concurrently, basically to simplify the example.- radarini
- Post #9
- Forum: Microsoft: Office
-
Data from range to rows
No merged cells. I'm looking for a formula solution. I would like for this formula to be ongoing. The range(s) represent monthly values generated basically by projects as I tried to indicate in my example above - Project Alpha has three distinct phases. The entire project duration is nine...- radarini
- Post #7
- Forum: Microsoft: Office
-
Data from range to rows
OK, here is a simple sample of what I have- Project:......Alpha...................Beta Phase:.....Ph 1...Ph2...Ph3.....Ph1...Ph2...Ph3 Month 1............20....25.....10.........15....5.....30 2............20....25.....10.........15....5.....30...- radarini
- Post #4
- Forum: Microsoft: Office
-
Data from range to rows
I need to create a single row of data from a range (5 cols, 20-30 rows). Also, once the values in the range = 0, I need to move to the next column. thnx- radarini
- Thread
- Replies: 8
- Forum: Microsoft: Office
