Search:

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

Search: Search took 0.01 seconds.

  1. Re: Complicated Match/Lookup in between dates formula?

    https://www.dropbox.com/s/3320yzevcgjagin/Sample%20Data.xlsx?dl=0

    Try this one. Sorry for the gap in conversation, I was traveling for business.
  2. Re: Complicated Match/Lookup in between dates formula?

    https://www.dropbox.com/home?preview=Sample+Data.xlsx
  3. Re: Complicated Match/Lookup in between dates formula?

    A would be correct, I need the nearest previous date, only if it is not between a set of dates.
  4. Re: Complicated Match/Lookup in between dates formula?

    Here is the actual data from my workbook. Note that this info is contained on different pages. In this case, could you write the formula trying to get the Related Weekly Spend number from Sheet2 into...
  5. Re: Complicated Match/Lookup in between dates formula?

    These do not seem to be working when I switch the columns I am using into the formula and I can not figure out why. I could send you the actual workbook I am using, however I do not see an attachment...
  6. Complicated Match/Lookup in between dates formula?

    Objective: I am trying to obtain a number (ID) from Table A based off of the Date and Number in Table B. What I am trying to say in my formula is that if Phone Number in Table B is equal to a Phone...
  7. Re: Bringing Values to Top of Column Formula?

    Ah, yep, learned something new. This one works perfect. Thanks very much.
  8. Re: Bringing Values to Top of Column Formula?

    This is the exact formula I am using.

    =INDEX($N$2:$N$999,AGGREGATE(15,6,(NOT(ISBLANK($N$2:$N$999))*ROW($N$2:$N$999)/--NOT(ISBLANK($N$2:$N$999))),ROWS($N$2:N2))-1)

    All I did was change the C's...
  9. Re: Bringing Values to Top of Column Formula?

    Hmm, when I plug the column I am using into this formula, it is putting the value right beside it instead of bringing it to the top of the column. Where am I going wrong?
  10. Bringing Values to Top of Column Formula?

    I assume I need some ARRAY formula, but not sure how to do it. I have blank cells and cells with a value in column C and Column D is the formula I am trying to make. I want to move all values in...
  11. Re: Need help with formula extracting values based on criteria

    whole value of the cell.
  12. Replies
    8
    Views
    291

    Re: Sumif with a defined named table?

    Yes, the other parts work fine, I just dont know how to add this to what I already have.

    SUMIFS(D:D,H:H,"Jun 2018",D:D,">0")

    This formula works with these 2 criteria, but adding this one to it...
  13. Replies
    8
    Views
    291

    Re: Sumif with a defined named table?

    COLUMN F IS JUST A ROW OF DATES, AND COLUMN G IS JUST A NUMBER. MY ENTIRE FORMULA IS THIS

    =SUMIFS(D:D,H:H,"Jun 2018",D:D,">0",C:C,"<>KNOWN_REVENUE")

    SAYING I WANT THE VALUE OF COLUMN D, IF...
  14. Replies
    8
    Views
    291

    Re: Sumif with a defined named table?

    Looks good. One more question. If I had multiple criteria, like this, as well as (F:F,"Jun 2018") and (G:G,">0"), what would the formula look like to add all these together into one formula?
  15. Replies
    8
    Views
    291

    Sumif with a defined named table?

    All I am trying to say is I want the sum of column D if no value in my defined named revenue (KNOWN_REVENUE) matches anything in column C.

    This is probably way off.
    ...
  16. Re: Need help with formula extracting values based on criteria

    [QUOTE=Peter_SSs;5158910]Try this, copied across and down.

    Unknown


    <tbody>

    C
    D
    E
  17. Need help with formula extracting values based on criteria

    So I am trying to find a formula that will pull out unidentified charges from our bank account. I have a list of the known item charges and I would like to create a formula that will list all the...
  18. Replies
    5
    Views
    349

    Re: Sumifs with or, question

    Yep, you are right, it was correct, looks like I shifted a column and it was trying to look at the wrong cell, thanks guys!
  19. Replies
    5
    Views
    349

    Re: Sumifs with or, question

    Hmm, that doesnt seem to work either as it brings back a #VALUE !
  20. Replies
    5
    Views
    349

    Sumifs with or, question

    So I have a sumifs formula I need to make and here is what I have.

    =SUM(SUMIFS(D:D,H:H,"Jul 2018",E:E,{"*AMZN MKTP*","*AMAZON MKTPLACE*"}))

    It doesn't seem to be working but what I am trying to...
  21. Replies
    2
    Views
    129

    Re: Categorizing formula

    OK, but what would the formula be to put all the paymentech payments from example A into a cell under the correct month?
  22. Replies
    2
    Views
    129

    Categorizing formula

    So we have bank statements that come in and we are trying to organize everything from example A to look like example B. To do this, we need to have a formula that takes into account the date, to put...
  23. Replies
    5
    Views
    159

    Re: Searching for multiple values in a cell

    Yep, this works. The other one would have probably worked as well, but I have more than 2 text values even though my example only shows ADK and DHEA. Thanks guys!
  24. Replies
    5
    Views
    159

    Searching for multiple values in a cell

    I am trying to search for multiple values in a cell and if it find one of them, I would like a text value assigned to the cell. Here is my formula so far.
    ...
Results 1 to 24 of 24