I have a list of suppliers in excel file, i want to auto generate number against each suppliers for every transaction, this formula will auto find previous number and will generate next number for each supplier. kindly help me to sort out this.
File is attached for referene.
Bookmarks