M
Mike U.
I'm currently using the following formula to count the
number of "early" vendor deliveries in a spreadsheet
=SUMPRODUCT(--($N$8:$N$25000="Early"),SUBTOTAL(3,OFFSET
($N$8,ROW($N$8:$N$25000)-MIN(ROW($N$8:$N$25000)),,)))
I also use a variation of this formula to reveal"on-time"
and "late" deliveries as well.
The beauty of this formula is that it allows me to apply
an AutoFilter to some or all of the vendors and the
corresponding early, on-time or late values change
accordingly.
Now for the challenge...
As part of the above spreadsheet, I also have products
associated with each of the individual deliveries. What
I'm trying to do is identify the names of the 1st, 2nd and
third most frequently occuring products in the list
(unfortunately these do not remain constant from month-to-
month). The first, second and third product names will
then need to change as the AutoFilter is applied to
vendors in the list.
I suspect that some combination of sumproduct, vlookup,
max, etc. will do what I need. I just haven't figured out
how to do it.
Any ideas on how to accomplish this would be much
appreciated.
Thanks
number of "early" vendor deliveries in a spreadsheet
=SUMPRODUCT(--($N$8:$N$25000="Early"),SUBTOTAL(3,OFFSET
($N$8,ROW($N$8:$N$25000)-MIN(ROW($N$8:$N$25000)),,)))
I also use a variation of this formula to reveal"on-time"
and "late" deliveries as well.
The beauty of this formula is that it allows me to apply
an AutoFilter to some or all of the vendors and the
corresponding early, on-time or late values change
accordingly.
Now for the challenge...
As part of the above spreadsheet, I also have products
associated with each of the individual deliveries. What
I'm trying to do is identify the names of the 1st, 2nd and
third most frequently occuring products in the list
(unfortunately these do not remain constant from month-to-
month). The first, second and third product names will
then need to change as the AutoFilter is applied to
vendors in the list.
I suspect that some combination of sumproduct, vlookup,
max, etc. will do what I need. I just haven't figured out
how to do it.
Any ideas on how to accomplish this would be much
appreciated.
Thanks