One way to flag it
Assuming your master list of existing suppliers is in A2 down,
& your big list of all suppliers is in B2 down
In C2: =IF(B2="","",IF(COUNTIF(A:A,B2),"Existing","New"))
Copy C2 down to the last row of data in col B. This flags it as required.
You can then autofilter on col C as desired, and/or make use of col C in your
pivot analysis.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"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?