Hello,
I am intermediate-skilled with lookup formulas, VBA, SumProduct etc. but the project I'm on now is a different beast. I need to build transaction maps, so of a large table of data, I'd like to pull a smaller table for a quarter.
Basically this is the step I can't figure out a great way to do. I can find, summarize, manipulate data based on conditions, but pulling a TABLE of data is new to me. I'm imaging a lookup for the first item in the quarter, then using OFFSET to select down until the next quarter begins. I can't quite piece it together. Any ideas? Thanks.
I am intermediate-skilled with lookup formulas, VBA, SumProduct etc. but the project I'm on now is a different beast. I need to build transaction maps, so of a large table of data, I'd like to pull a smaller table for a quarter.
Basically this is the step I can't figure out a great way to do. I can find, summarize, manipulate data based on conditions, but pulling a TABLE of data is new to me. I'm imaging a lookup for the first item in the quarter, then using OFFSET to select down until the next quarter begins. I can't quite piece it together. Any ideas? Thanks.
