Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds; generated 1 minute(s) ago.

  1. Thread: Excel formula

    by igold
    Replies
    2
    Views
    55

    Re: Excel formula

    Small typo in the above formula. Should be:

    =IF(COUNTIFS($B$1:B1,B1)/B1=1,B1+1,B1)
  2. Re: Selecting data based on cell entry higher in column

    Hi, this code works on your above request. That said, there is no set pattern on what you colored headers(or materials) change to in the body of the description. For instance "Pre- insulated 204x60"...
  3. Re: Making multiple userform entries populate one cell

    Hi, I don't have an answer for you but I want to thank you for giving me my chuckle for the day with the following quote from your post...



    Please take this in good-natured fun with no ill will...
  4. Replies
    6
    Views
    76

    Re: VBA runtime 91 error

    If you have a limited knowledge of VBA, then one of the things you should start doing is to use "Option Explicit" at the very top of your code. Amongst other things, this will force you to declare...
  5. Replies
    2
    Views
    88

    Re: Transpose rows based on specific text

    How about this. I output to the same sheet starting in Cell C2 (last line of code) as you did not indicate anything different. Additionally, this will work only if the format of the original data...
  6. Replies
    2
    Views
    163

    Re: Chart based on Store selection

    I think your problem lies in how you have your data laid out. If it were me, I would have 3 Columns of data. The header row would be STORE#, DATE, SALES. I would then move the sales data to the...
  7. Replies
    5
    Views
    119

    Re: Searching an array for a match

    You're welcome.
  8. Re: Copy rows based on keyword list to second sheet

    I am sorry I could not be more help. At least you got a bump out of it and Fluff got it done for you.

    Thanks for the feedback.
  9. Re: Copy rows based on keyword list to second sheet

    Fluff

    Nice!

    igold
  10. Re: Copy rows based on keyword list to second sheet

    I downloaded your workbook, and it is not as described in your post. You have the software name, version number, department name all in column A separated by commas. I can break that information out...
  11. Replies
    5
    Views
    185

    Re: Why won't this return a BLANK cell?

    Have you clicked on the Fx button to the left of the formula bar while your formula is in the bar to see what each part of your formula is returning...
  12. Replies
    5
    Views
    185

    Re: Why won't this return a BLANK cell?

    Out of curiosity, with the same data that you are using for the IF statement in your OP =IF(OR(F3>0, O3>0,F3-((IF(SUM('Week 42:[Week 52]Week 52'!P3)>0,SUM('Week 42:[Week 52]Week 52'!P3))))), " ") ...
  13. Re: Copy rows based on keyword list to second sheet

    You are welcome, I was happy to help.

    If it does not work for you, let us know and I am sure a solution can be found.
  14. Re: Copy rows based on keyword list to second sheet

    How about something like this. The software list you want to search for should start in Cell A1 on Sheet3.


    Sub GetSoftware()


    Dim ws1 As Worksheet: Set ws1 = Worksheets("Sheet1")
    ...
  15. Replies
    5
    Views
    185

    Re: Why won't this return a BLANK cell?

    I can't say for sure why it is returning zero, you may have a stray character in one of your cells. I can say for sure, that you are missing the "Value if False" part of your IF statement.
  16. Replies
    5
    Views
    119

    Re: Searching an array for a match

    There are lots of ways to get the UPC and Date that you want to search for into the search, I chose an InputBox. This code assumes that your first UPC,Date,Price row starts in Cell A2.


    Sub...
  17. Replies
    6
    Views
    56

    Re: Run formula if text is found in a cell.

    Yongle

    It was the red highlighting that did you in. :stickouttounge:
  18. Replies
    6
    Views
    56

    Re: Run formula if text is found in a cell.

    Is this what you are looking for...

    =IF(L2="open",IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past Due",IF((TODAY()+7)>E2,"Due Soon","")))),"")
  19. Replies
    2
    Views
    78

    Re: Find Multiple Command For VBA in Excell

    You could use a manual or a VBA AutoFilter with multiple criteria. From this part of your post



    it seems like you are probably wanting to copy the rows to somewhere else, which an AutoFilter...
  20. Re: Vba for each cell in rng insert dynamic formula

    You're welcome.
  21. Re: Vba for each cell in rng insert dynamic formula

    If I understand your requirement, does this do what you want...


    Sub test()


    Dim arr
    Range("B2").Formula = "=sum(B$1,$A2)"
    Range("B2").AutoFill Range("B2:B517")
    arr =...
  22. Re: Vba for each cell in rng insert dynamic formula

    This...


    Sub test()


    Range("B2").Formula = "=sum(B$1,$A2)"
    Range("B2").AutoFill Range("B2:B517")

    End Sub
  23. Replies
    7
    Views
    395

    Re: Help Needed for unique task

    How about the actual line of code. Your line 42 is not necessarily my line 42...

    Also was this the entire error message



    or was there additional info provided...
  24. Replies
    4
    Views
    246

    Re: Which one cost more memory to run?

    You're welcome, and yes the speed difference would be exponential. The reason being that with an array all work is being done in memory, while having your code going back and forth to the sheet to...
  25. Replies
    4
    Views
    246

    Re: Which one cost more memory to run?

    The way you phrased your post, I am not 100% sure of what your asking. You say that you are used to storing data in arrays, but of course when you re-run the macro, the data is erased and re-written...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4