Search results

Okay, as a starting point, I used the Lookup worksheet and only cell set up the Calls per hour. Eventually you could leave the lookup array here and move the basic formulas in rows 2 and 3 to ScoringComp. I changed the name to take out spaces and shorten for easier setup. You would need one...

Howdy. Are you doing this in Excel? IIF is not in Excel. ________ Honda VT250 specifications

When you write "number of records", how many do you mean? I setup weekly data pulls into Excel, involving many worksheets with several hundred thousand data pieces in each [row/col combinations) (in a separate workbook, then used formulas for setup/summary in same workbook), and finally the...

Howdy. Did you follow the directions per Tom Urtis? There should not be a problem with saving the file, unless some code is involved itself that changes Save options. ________ WEED BUBBLERS

Howdy. I found in a couple of situations, it was easier to pull the data separately onto separate worksheets, then use another worksheet to consolidate (using formulas). It gives move flexibility in displaying what and how you want. ________ GLASS PIPES

Actually, VBA commands to hide columns are simple. Then you only need to password protect the VBA Project. Tom Urtis has provided the method to password protect VBA code ________ AMC AND JEEP TRANSMISSIONS

Howdy, and welcome to the board. Actually, you can nest more than 7 IFs, but it involves some helper cells (one cell for each set of seven IFs); I've done as many as 18. And it works. But, it is difficult to trouble shoot and maintain. So you would need to document the process thoroughly...

Brian, nice new title you have there! :) ________ Mflb

You have encountered the problem of security with Excel. No matter how you approach it, someone can break the password. VBA would be one way to handle a better level of security for passwords, then you can lock the VBA Project. BTW, the password is primarily to prevent casual users from making...

Howdy. Best way to do this is setup your graph data separate from the actual data (starting in B2), then use this formula in the graph setup data (starting in B10): =IF(B2="",NA(),B2) Copy and fill down/across as needed. NA is a function that will not plot. The IF function can be more...

Howdy, and welcome to the board. Change the NOW() to NOW()-1 ________ IOLITE REVIEW

Assume data is in columns A:B. Put the name Dave in D1 and Paul in D2. Then in E1 put this formula: =SUMIF($A:$A,D1,$B:$B) Copy to E2 ________ CHRYSLER VOYAGER HISTORY

Howdy. I would probably add another column and do a concatenation of the two columns for lookup, then use that in the INDEX/MATCH formula. You can always hide that helper column. This is easier to troubleshoot as well. ________ Vista

The best place to start is to use the Help information in Excel itself. There is a surprising amount of information. After reading that and experimenting, if you have specific questions, then post the question. People here like to help by answering questions (check the history of posting here)...

Thanks for follow up. One caution - sometimes you will find a difference between how one program performs calculation and another program. Thus, you could find slight variations int hye calculated percent vs. what was supplied. Then you have to determine which is more accurate. ________ Honey oil

Howdy. Yes, it is possible. There are two ways to approach it. 1. Use VBA for a complete, end-to-end solution. This is not a simple task, but certainly doable. 2. Work with another worksheet in Excel that pulls the data from the imported data (also in Excel). Then give that a dynamic named...

If you are sure that it works in every possible situation, and you have tested... Another issue is efficiency. I spend a fair amount of time looking for more efficient ways to accomplish tasks. That had led to job security, such that I trained other people to design and develop solutions for...

Given that formula, you realize that you also have an upper limit on the number of characters in a formula (1,024 characters)? And how would you trouble shoot? Well, if that twirls your hat... :D ________ Buy Vapor Genie

Well, you can nest up to seven IF statements in one formula. To go beyond that you would need a series of formulas in different cells (to eventually get to 49). I had produced one set that involved 13 IF statements in two formulas. It was a nightmare to set up, and even worse, to maintain, and...

Okay, this might be a little more complicated than at first glance. Normally, you would select a price from a drop down on Sheet1, and the other cells would populate (this saves clicking on Sheet2, and in fact, Sheet2 could be hidden). However, in your case, everytime you select a cell on...