Search:

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

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

by jwillits
Replies
22
Views
668

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. Thread: Complicated Match/Lookup in between dates formula?

by jwillits
Replies
22
Views
668

Re: Complicated Match/Lookup in between dates formula?

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

by jwillits
Replies
22
Views
668

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. Thread: Complicated Match/Lookup in between dates formula?

by jwillits
Replies
22
Views
668

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. Thread: Complicated Match/Lookup in between dates formula?

by jwillits
Replies
22
Views
668

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. Thread: Complicated Match/Lookup in between dates formula?

by jwillits
Replies
22
Views
668

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. Thread: Bringing Values to Top of Column Formula?

by jwillits
Replies
6
Views
201

Re: Bringing Values to Top of Column Formula?

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

by jwillits
Replies
6
Views
201

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. Thread: Bringing Values to Top of Column Formula?

by jwillits
Replies
6
Views
201

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. Thread: Bringing Values to Top of Column Formula?

by jwillits
Replies
6
Views
201

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. Thread: Need help with formula extracting values based on criteria

by jwillits
Replies
5
Views
327

Re: Need help with formula extracting values based on criteria

whole value of the cell.
12. Thread: Sumif with a defined named table?

by jwillits
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. Thread: Sumif with a defined named table?

by jwillits
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. Thread: Sumif with a defined named table?

by jwillits
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. Thread: Sumif with a defined named table?

by jwillits
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. Thread: Need help with formula extracting values based on criteria

by jwillits
Replies
5
Views
327

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. Thread: Need help with formula extracting values based on criteria

by jwillits
Replies
5
Views
327

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. Thread: Sumifs with or, question

by jwillits
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. Thread: Sumifs with or, question

by jwillits
Replies
5
Views
349

Re: Sumifs with or, question

Hmm, that doesnt seem to work either as it brings back a #VALUE !
20. Thread: Sumifs with or, question

by jwillits
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. Thread: Categorizing formula

by jwillits
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. Thread: Categorizing formula

by jwillits
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. Thread: Searching for multiple values in a cell

by jwillits
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. Thread: Searching for multiple values in a cell

by jwillits
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