View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Clint Clint is offline
external usenet poster
 
Posts: 17
Default assign next serial number based on contents of another cell

column A titled "serial number", column B titled "line item", column C titled
"cargo".
If column B contains 5 line items for the same cargo in column C, how do I
get column A to input the next serial number only after contents in Column C
has changed.