Hi - been trying to figure this out for some time with no luck! I have scoured the forum and have not found anything that can help.

Column B is the resulting document number with the unique number (formula already inserted to combine Columns D, E, F and G) - not sure if I need Column B or C for the formula in Column G??
Column C is the resulting document number without the unique number (formula already inserted to combine Columns D, E and F) - not sure if I need Column B or C for the formula in Column G??
Column D is the document type (from a drop down menu).
Column E is the application type (from a drop down menu).
Column F is the department ID (from a drop down menu).
Column G is the unique number for the document - this is where I'd like the formula to auto-generate this number based on what is chosen from the drop down menus; document type, application type, department ID - then assign next sequential number.

Looking for a formula that would auto-generate the number in Column G so that a duplicate document number is not assigned.

Capture.JPG