Just a note about dealing with Supplier Lists.......whenever possible do your
manipulations using their Supplier NUMBER, rather than their NAME, as the
same supplier can have his name on the list in several different spellings,
(which will return different results), but the NUMBER is always the
NUMBER.......

Vaya con Dios,
Chuck, CABGx3



"talalhisham" wrote:

what formula do i use to find new suppliers in a big list?
I have a spreadsheet with suppliers and qty of goods received for each of
them. I have formula in place to sum the qty of goods received for each
supplier. But I need a way of tracking any new suppliers delivering goods.
Any ideas?
I was thinking a formula and tracking all new suppliers under miscellaneous.
Any ideas?