Wednesday, March 18, 2015

yogi_Provide in Column B Row By Row Six Digit ID Based On Sequential Date Entries in Column A


                                           Google Spreadsheet   Post  #1927
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 18, 2015
question by cacgas:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cEOq4EmhQeQ
Need a formula for where the result is a six digit combination of the month & entry count
I have a results SHEET that populates from a FORM.  I would like to create a column in which the result yields a unique SIX DIGIT number derived from:
1). The MONTH of a date that is entered from the FORM (not the time stamp)  AND  
2). The count of which entry that was

E.g: The 38th entry with a date entered as 03/18/2015 would yield the following result:  030038
        The 7th entry with a date enterd as 04/14/2015 would yield the following result: 040007

Help much appreciated!
---------------------------------------------------------------------------------------------------------------------------