Search:

Type: Posts; User: NickRed18; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    1,798

    Re: count if and ignore blanks

    I had no idea about asterisks behaving that way! Is that a property unique to COUNT, or does it work for Match, Lookup, etc.
  2. Replies
    9
    Views
    1,798

    Re: count if and ignore blanks

    My range is A1:A25, so change as needed:

    =COUNTA(A1:A25)-COUNTIF(A1:A25,"this")-COUNTIF(A1:A25,"that")
  3. Re: Is it possible to find first non blank cell in a range and return the column that it's in as part of a formula build?

    Here is an example 10x5 matrix with a blank cell missing at Row 5, Column 3 (C5):

    1 11 21 31 41
    2 12 22 32 42
    3 13 23 33 43
    4 14 24 34 44
    5 15 __ 35 45
    6 16 26 36 46
    7 17 27 37 47...
  4. Replies
    8
    Views
    305

    Re: Index Match How to avoid blank cells

    Deleted
  5. Replies
    2
    Views
    107

    Re: Show photo in worksheet.

    Similar to .Show when using a userform?
  6. Replies
    2
    Views
    138

    Re: Filter Data Based on Multiple Criteria

    What exactly are you trying to filter? You said you would like to filter to see who is currently doing a particular job - does that mean highlight all names that are doing "Logistics", for example?
  7. Re: EXCEL VBA - Loop through range/collection

    Try the FIND worksheet function
  8. Replies
    9
    Views
    204

    Re: Excluding hours for processing time

    How are you entering in your Received and Processing End times/dates? Are there two separate cells: 1 for the time and 1 for date?
  9. Re: Excel Zoom Setting and Userform Placement Setting

    I found an old post with exactly what I needed. Thanks though.
  10. Replies
    6
    Views
    189

    Re: Creating complex search function

    The tasks you are looking up (Input), could you be looking up Task 1, Task 2, Task 3, Task 4, Task 5, Task A, Task B, Task C, etc.... just every task you listed? Or would you be looking up say Task...
  11. Replies
    7
    Views
    144

    Re: counting Qty of parts in a list.

    Well, how many part numbers do you have? If it's just a few, and you don't mind typing them out then you can use SUMIF:
    Ex: (This range starts in A1 and ends in B21)
    a 2
    b 12
    uioyu 18
    iuy 80...
  12. Replies
    1
    Views
    86

    Re: Extract Last Name

    Your
    Search(" ",A17) is still looking at the very first space in the string rather than the second space. Works fine for the full names without a middle one - there's only one space to worry...
  13. Re: Excel Zoom Setting and Userform Placement Setting

    Worf,

    Thanks for the bit of code! I would never have thought to iterate with zoom.
  14. Excel Zoom Setting and Userform Placement Setting

    Hey Everyone,

    I have been working on a VBA project for about the last 2 weeks, and I am confident enough in it to call it done (yay!).
    There is one thing, however, that is tripping me up... The...
  15. Replies
    11
    Views
    727

    Re: Userform Textbox Focus - Driving me crazy!

    I see what you're saying about the Return key being pressed twice, but just for clarification: The only items on the userform are the Textbox (ScanInput), and two buttons (AddNewItem and RemoveItem)....
  16. Replies
    11
    Views
    727

    Re: Userform Textbox Focus - Driving me crazy!

    Interesting. I would have guessed an error would occur.
    Do you know why trying to manually .SetFocus does not work?
  17. Replies
    11
    Views
    727

    Re: Userform Textbox Focus - Driving me crazy!

    Yeah I am in the dark on why KeyCode 0 works also. Even on Microsoft's website for Key Codes, 0 is not even listed
  18. Re: need Macro to delete entire rows that contain letter Z in Col A

    My apologies about the misunderstanding. Thought you just needed it deleted.
  19. Thread: hyperlink

    by NickRed18
    Replies
    14
    Views
    249

    Re: hyperlink

    I'm terribly sorry about the trouble... I promise I test my code before I reply, so I'm not sure why it's not working anymore.
    I think I fixed it. Once again, I apologize. Where it says [Main Sheet...
  20. Thread: hyperlink

    by NickRed18
    Replies
    14
    Views
    249

    Re: hyperlink

    No you do not need to remove the green comments, unless you want to. The reason it may not be working is it's located in the wrong spot. Open up VBA and in the top left window, it lists your...
  21. Thread: hyperlink

    by NickRed18
    Replies
    14
    Views
    249

    Re: hyperlink

    Edited code with your sheet name and the correct range of comments


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Worksheets("Sheet1").Activate
    If...
  22. Re: need Macro to delete entire rows that contain letter Z in Col A

    I know there's ways to do this without loops, but here:


    Sub DeleteZ()
    Dim i, j As Integer

    For i = 1 To 16 '1 to however long your column is
    For j = 1 To...
  23. Thread: hyperlink

    by NickRed18
    Replies
    14
    Views
    249

    Re: hyperlink

    LadyHarper,

    You can setup an event on your Main Worksheet to run every time you select a cell with your comment in it. In my code, I set my range of comments to "A2:A8", so you would change that...
  24. Replies
    9
    Views
    173

    Re: Complicated formula needed

    Thanks ErikTyler for catching that!

    My mistake mhawkins, I misunderstood the dependent aspect of your question. I thought the rates applied to the age of the employee, and then the number of...
  25. Replies
    6
    Views
    355

    Re: vbs to activate a macro with click

    If you use the Task Scheduler from the link I provided in my first reply, you can set it up to open your excel workbook once per day, twice per day, 100 times a day, etc.. however many times, and at...
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4