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: *

  • Users: NumberCrunchingMonky
  • Order by date
  1. NumberCrunchingMonky

    "Find Next" Command

    I use the script below to search for names that appear in Column B of an excel worksheet. It's linked to a cell in which the name is typed. It works fine for a single name. However, if there are muliple records with the same name I cannot get it to "find next" when I hit the button a second...
  2. NumberCrunchingMonky

    Script Issue--unable to debug

    I have some script that changes the visual effect of three buttons upon mouse-over, but the 7th line from the bottom highlights yellow during the event, indicating an issue. I do not know what is causing this. Here's the line: Set OleObj = Me.OLEObjects("Label" & i) Here's the script in...
  3. NumberCrunchingMonky

    Count unique values in Excel

    Put policy in as your second data range. As a general rule, I "fool proof" the formula to ignore blank cells, as they'll limit the formula: So, your formula would be: {=SUM(IF(COUNTIF(POLICY,POLICY)=0," ",1/COUNTIF(POLICY,POLICY)))} NMC
  4. NumberCrunchingMonky

    Highlight Button...

    I created a database in Excel and attached buttons to control macros. No problem. I'd like to add code that will change the appearance of the buttons from raised to sunken when the cursor/pointer moves over them, like in html app's. What code can I add to do this, and where should it go...
  5. NumberCrunchingMonky

    Add Search Box to Workbook

    Thanks cLFLaVA--I appreciate your help. I'm having an issue with line 4, though: "If shtObj.Range("A" & i).Value = szSearch" Thanks. Monky
  6. NumberCrunchingMonky

    Add Search Box to Workbook

    I've scoured probably 200 archives looking for this solution and I cannot find it... How can I add a Search Box to a worksheet? I want to configure it so that: - I type the name in a cell (let's say its D1) - Column A is queried - The cell in Column A that contains the word typed in D1 is...
  7. NumberCrunchingMonky

    % Difference Calculation Issue

    Fantastic. Thanks, Tony for your help. It works perfectly. The ABS function is (for lack of a better word...) "neat". And thanks again, Blue. I did a search on old threads for this and saw a post of yours that suggests a test of: IF(ISERROR(0/A1," "... which was brilliant. That's now on my...
  8. NumberCrunchingMonky

    % Difference Calculation Issue

    Hi Blue: Thanks for the formula. It works well, but I neglected to include a caveat: if the plan value is "0" then I get a Div# error; further, I'd like to add "if Actual is 20% above or BELOW plan (I think I left that out of the original post). I know the "IF(ISERROR(" trick, but integrating...
  9. NumberCrunchingMonky

    % Difference Calculation Issue

    What would a formula look like to solve the following issue? Plan Actual Difference 5,000 1,000 4,000 What I want to do is this: If the Actual is 20% above of below the plan, then return the difference of the two numbers (if the actual was above plan, then the number would be...
  10. NumberCrunchingMonky

    Rounding Downward?

    Good solutions--thanks! NCM
  11. NumberCrunchingMonky

    Rounding Downward?

    It seems that Excel rounds upward by default at the .5 point in a whole integer. Is there a non-formula way (or non special format way) to get it to round downward at .5 (and below)? So, any increment above .5 would round upward; but any increment at .5 and less would round downward to the...
  12. NumberCrunchingMonky

    Using text string in SUMPRODUCT

    That works--thanks Ken! Regards. NCM
  13. NumberCrunchingMonky

    Using text string in SUMPRODUCT

    Outstanding. Fellas--thanks. Tony--Your formula works perfectly in this project. Skip--Your formula fits great in another report I'm creating(and probably 10 others I can think of). In fact, it precluded me from posting another question. Many, many thanks. Regards. NCM
  14. NumberCrunchingMonky

    Using text string in SUMPRODUCT

    I'm trying to configure SUMPRODUCT to use a part of a text string as my criteria. For example: A B C 1 Code State Total 2 123_ABC_456 NY 50 3 123_GHI-456 NY 50 4 234_ABC_567 NY 50 5 234_GHI_567...
  15. NumberCrunchingMonky

    "Looping" Script

    Thanks, Steve, for your great help. I'll give this a shot. Regards. NCM
  16. NumberCrunchingMonky

    Doing the equivalent of a SUM and a GROUP BY in Excel

    I love SUMPRODUCT because it does what SUMIF does, but one can use a cell reference instead of having to use a fixed "text" value--a huge plus since you can have many GL numbers. First, get a unique list of the GL numbers (select range, Data-->Filter - Advanced Filter; check "Copy to another...
  17. NumberCrunchingMonky

    "Looping" Code

    In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the...
  18. NumberCrunchingMonky

    "Looping" Script

    In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the...
  19. NumberCrunchingMonky

    Tagging Duplicates

    Thanks a bunch luceze, stray and Glenn. Monky
  20. NumberCrunchingMonky

    Tagging Duplicates

    Thansks for your help Luceze, but it returns the same code. I'm looking for a return of the other code. For example: A B C 1 NAME CODE FORMULA 2 John Doe 12345 23456 3 John Doe 23456 12345 Regards, NCM

Part and Inventory Search

Back
Top