I want to extract the numbers that match the customer, product and month.
I have two spreadsheets that will be linked. I want only data for certain
months, but the base spreadsheet will change every month. For example: I
want to see the next 3 months data only, thus I want to be able to create a
smaller spreadsheet that selects only the 3 months of relevance. I want this
function to be as automated as possible so every month in can quickly and
easily find the months information I request. It is a 12 month outlook and I
don't want to see all of it, just what is relevant.
Thanks for your help and I hope this makes some sense. I am starting to
confuse myself.
"Biff" wrote:
Hi!
This is relatively easy to do but it would help if you
could post a sample of your data and explain what data
you're trying to extract.
Biff
-----Original Message-----
My initial spreadsheet contains a table of information, I
am trying to create
a new spreadsheet with a cleaner version of the
information. I am trying to
use the INDEX and MATCH functions; however, to return my
values I must
consider three constants: customer, product, and date.
So far I have only
been able to find a way to use two constants. All three
must be considered
because many customers purchase a variety of products.
The date is
horizontal while customer and product are both vertical.
.
|