Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Supplier list
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Supplier list
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Supplier list
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by Month and supplier | Excel Worksheet Functions | |||
Supplier scorecard | Excel Discussion (Misc queries) | |||
Select Minimum value and return the name of the supplier | Excel Worksheet Functions | |||
how to create refrence using first and last words of any supplier | Excel Worksheet Functions | |||
how to create refrence using first and last words of any supplier | Excel Worksheet Functions |