Hi! I need some help with my table, the problem is this....


Date---------Basket1 Basket2 Basket3 Basket4 Basket5
01-01-2006-----12-----5-------28--------44--------50
02-01-2006-----1------4-------32--------44--------6
03-01-2006-----12-----2-------45--------34--------49
04-01-2006-----22-----8-------19--------32--------1


I want to create a code that shows if anyday there was the same
products buyed, exemple: If i write 12,5,28,44,50 the code should
answer Yes, in 01-01-2006 or given this litle table, if i write
1,5,32,44,6 the code should anwser No. The code should only analyse row
by row (By Date) and it could be able to answer if i write more that
five products, exemple, if i write products 22,18,19,32,1,4,44,6, it
should answer Yes 02-01-2006 and in 04-01-2006.
Because the combination of this products result in two diferent buys!

The other problem is this, imagine that the every mumber written is an
product , now i want a code that show me how long a product ins't
buyed, exemple, if i write Product Number: 12, the code should answer:
Product 12 was last buyed 03-01-2006, 1 times since the last
operational day (04-01-2006)


Thank you very much if someone could help me...


--
l.o.c.o.s
------------------------------------------------------------------------
l.o.c.o.s's Profile: http://www.excelforum.com/member.php...o&userid=31182
View this thread: http://www.excelforum.com/showthread...hreadid=508491