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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AllanB1

    Specify Range Function

    Deniall: Yes thank you. I was also successful in using this variant in all the examples in the snippet. =SUMPRODUCT( --(ISERROR(A:A)) )
  2. AllanB1

    Specify Range Function

    Deniall: Your pay grade and mine, my friend. Something so seemingly simple... Anyway, I replicated my situation in a "snippet" sheet, link provided. For some reason the #NUM error I brought up in my last message no longer occurs, don't even...
  3. AllanB1

    Specify Range Function

    1. Skip, yes I agree that structured tables and named ranges are very effective tools in data organization. Are you saying that their use may in some way resolve the situation I presented in the preceding message? 2. Deniall, I also am using XL 2010, under Win7 Pro. 3. These 2 formulas you...
  4. AllanB1

    Specify Range Function

    Question, if I enter =SUMPRODUCT(ISERROR(A1:A65000) * (B1:B65000="PREVENTIVE")) (or any other start/end cell ranges), I obtain a correct result. However, if I use =SUMPRODUCT(ISERROR(A:A) * (B:B="PREVENTIVE")) (column ranges), I get the #NUM error. Any obvious explanation?
  5. AllanB1

    Specify Range Function

    Skip/Deniall: The SUMPRODUCT() variations you presented work well for my purpose. And I agree, its versatility can be adapted for many purposes. I hadn't considered it before. Thanks again.
  6. AllanB1

    Specify Range Function

    ...In lieu of making this work, I simply employed an additional logical test column H and used this successfully: =COUNTIFS($H:$H,"=TRUE",$C:$C,"*PREVENTIVE MAINT*") I realized I could do this initially, but was seeking a method without using an additional column. What I was originally...
  7. AllanB1

    Specify Range Function

    Skip: I'm sorry I didn't explain my intent that well. I was using the ISERROR() function only as one example of what I was trying to achieve. While I realize there are other ways to do what the following formula shows, my question is, can I achieve my desired result using a function like...
  8. AllanB1

    Specify Range Function

    I realize that. My question is more of a general one though and I used ISERROR() as an example. Essentially, is there any range parameter I can use - i.e., between the ISERROR(??) parentheses - to make an aggregate function perform? BTW, the 3 examples I provided in my initial message don't...
  9. AllanB1

    Specify Range Function

    Sorry, I should have explained. Using COUNTIFS(), I'm trying to compare the contents of cells in columns C and G. If there is an error in G cell AND C cell contains PREVENTIVE MAINT, I want the count of those rows meeting that condition. Thanks.
  10. AllanB1

    Specify Range Function

    ...am looking for a way to make the ISERROR function work over a range. I have tried the following to no avail: =COUNTIFS($G:$G,"=ISERROR()",$C:$C,"*PREVENTIVE MAINT*") =COUNTIFS($G:$G,"=ISERROR(G:G)",$C:$C,"*PREVENTIVE MAINT*")...
  11. AllanB1

    Excel Pivot Table: Show averages by value range

    Great. Thanks Skip.
  12. AllanB1

    Excel Pivot Table: Show averages by value range

    Won't allow me to group that selection. It's in number format.
  13. AllanB1

    Excel Pivot Table: Show averages by value range

    Anyone know of a way to group data by number ranges (1-10, 11-20,...)? I know I can come up with something in a usual spreadsheet, but does the pivot table offer any way like it does with dates, ie., by week? For example, I need to know an average cost by vendor for 1-10 miles, etc. Thanks.
  14. AllanB1

    CONTROL Class vs. CONTAINER Class

    Mike/Olaf thanks for further expounding on this subject. I have never seen much difference between the two myself, but thought I'd put this out for public discussion. Thanks. Allan
  15. AllanB1

    CONTROL Class vs. CONTAINER Class

    Olaf, thank you for your excellent explanation. I can't see much difference either, except that you are unable to edit objects contained within a control class, but I don't consider that an advantage. Allan
  16. AllanB1

    CONTROL Class vs. CONTAINER Class

    Hi. What would be advantages to using a control class over a container class? Some purposes or applications for using a control class, rather than a container class please? Thanks. Allan
  17. AllanB1

    Omit Deleted Records from SQL-Select Query Results

    Good catch Olaf. I thought SET DELETED was ON, but it wasn't. Al
  18. AllanB1

    Omit Deleted Records from SQL-Select Query Results

    Hi. Without PACKing the table, how would you exclude the deleted records from the query result? ...WHERE !DELETED() doesn't do it. Thanks. Al
  19. AllanB1

    Selecting Picture Behind Text

    Fantastic. Thanks Tony.
  20. AllanB1

    Selecting Picture Behind Text

    Hello. I inserted a picture into a document with a wrapping style "behind text". Now I can't seem to select it because it is behind the paragraph text. How do I bring it to the foreground so I can select it? Thanks.

Part and Inventory Search

Back
Top