ST Alpha - "I may be dense but I'm still not seeing how I get the positive invoices for the year where the account had at least one negative invoice." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

In response to "LIR Dano here's a Google sheet using examples for Pivot and Filter functions, if that helps -- (link*)" by Max

I may be dense but I'm still not seeing how I get the positive invoices for the year where the account had at least one negative invoice.

Posted by Dano (aka dano) Nov 5 '20, 16:23

Account 123
2015: 4 invoices, all positive - I don't want any of those invoices
2016: 5 invoices, 1 negative and 4 positive - I want all 5 of those invoice numbers

So far I sorted by Account, then Year, then Amount (low to high) and I have an IF statement that says if the Account or the Year changes from the previous row and the Amount is negative then put "YES" in the cell.

Now I'm trying to figure out a non brute force approach to say once you see a Yes, then I want to keep seeing a yes until the Account or Year changes. At that point do the original If and start again.

Responses:

oh, I overlooked an element, but I think I can do that -- nm - Max Nov 5, 16:25 1
- I've switched back from a Pivot Table and am now thinking VLOOKUP - Dano Nov 5, 16:32

Post a message top

I may be dense but I'm still not seeing how I get the positive invoices for the year where the account had at least one negative invoice.

Replies are disabled on threads older than 7 days.