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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hour Run rate by month
I would like to create a formula that will calculate a runrate, hours for example for a given number of periods. My current page will show the manager what the previous month's data was as well as what is scheduled for the current month per task. What I would like to add is a column called...- mattalin
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Unique Number Formatting
Wonder if the following is possible in Excel: Let's say I have the following numbers (which are generated when I export from an internal query s/w program, Brio, into Excel): 1 101 10102 10103 1010301 1010302 102 I would like to be able to automatically convert each of the above to the...- mattalin
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Advanced Lookup??
I have an extremely large amount of data and I need to use some function of Vlookup or similar. Here's an example, I would like to "lookup" both the "WBS" and "Description" columns based on 2 criteria and display information in the "Finish" column...- mattalin
- Thread
- Replies: 5
- Forum: Microsoft: Office
