Backboards: 
Posts: 155
In response to "oh, I overlooked an element, but I think I can do that -- nm" by Max

I've switched back from a Pivot Table and am now thinking VLOOKUP

If it helps I have a column that has "YES" in the cell for the first invoice for an Account/Year combination that has a negative amount.

So I can easily get all Account/Year combinations that are relevant.


Post a message   top
Replies are disabled on threads older than 7 days.