View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
 
Posts: 310
Default Data validation - restrict duplicate value

Hi!

How to set data validation function (in column B) to restrict user from
entering same invoice number from same supplier?
Column A: Supplier
Column B: Supplier Invoice Number

TIA