View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel_Oz Excel_Oz is offline
external usenet poster
 
Posts: 8
Default Lookup and Reference (without duplication)

Because we are sorting the information into 2 distinct alphabetical
piles, we need to use Vendor ID's which are Alphabetical. These Vendor
ID's are listed within the raw data more than once - which means there
is more than 1 transaction outstanding for that vendor.