Dynamic "table" lookup in Excel 2007/10
Posted on 2011-10-08
Hi guys -
I'm not sure if Excel can do this - nor what it's 'technically' called, so maybe you can help.
I have a table in excel of data and dates. Well what I want to do is take a dynamic range of that data, like say between 1/1/2010 and 7/3/2010 and then evaluate that on another worksheet. I've been using COUNTIFS(...) to get what I want - but I haven't figured out how to make that be a filtered range on a dataset so I've been manually deleting the dataset down to what I want and going from there.
Is there a way possible in Excel to do this, or do I manually have to modify my table size every time?