Assuming that you have all the data needed in Excel, then yes, most
likely you can do that.
Start with one of your customers and work through what you need,
developing a formula as you go. Then move down the list. After doing
a few you'll probably have worked out how to generalize your formula to
make it work with the entire list.
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=515601