Great thanks - I now have an automatic numbering system for Repair Cafe bookings which includes the item number and the repair cafe number. Nice and simple, and always unique.
Is it possible to make a sequence that gets 1 larger every time (maybe with a nested sequence in a sequence?): 0.1, | 0.1, 0.2, | 0.1, 0.2, 0.3, | 0.1, 0.2, 0.3, 0.4 | etc. (i just put | for readability). It seems useful. So far I have been using ROW for sequences with steps of 1 (1, 2, 3, 4, ...) but I struggled to figure out how to do things by for example 2 steps at once (1, 3, 5 ,6, or 1, 1, 2, 2, 3, 3....). Seems like I can at least use this for those cases.
G'day and thank you for your video. I've been searching left and right for the following solution - THANK YOU FOR ANY HELP YOU COULD PROVIDE :) I need a dynamic sequence for each prospect I enter in my Google Sheet AA-0000 whereas the 2 Letters will move to the next logical letter after 9999, as follow: AA-0001, AA-0002, AA-0003... AA-9999 > AB-0001, AB-0002, AB-0003... AB-9999 > AC-0001... Once AZ-9999 comes around, we continue with the next logical letter: AZ-9999 > BA-0001, BA-0002, BA-9999 > BB-0001, BB-0002, BB-0003
i got case here, i want make serial number with multi criteria such as this: A B B A C B A B, and i want A1 B1 B2 A2 C1 B3 A3 B4, repeated sequence with criteria A B C
Thank you for this tutorial! It was super helpful in creating what I needed! You rock!
Thanks - very helpful in setting up a look-up table on a sheet where each value should have a unique id.
Great thanks - I now have an automatic numbering system for Repair Cafe bookings which includes the item number and the repair cafe number.
Nice and simple, and always unique.
Thanks for the kind kind words
Regards!
Is it possible to make a sequence that gets 1 larger every time (maybe with a nested sequence in a sequence?): 0.1, | 0.1, 0.2, | 0.1, 0.2, 0.3, | 0.1, 0.2, 0.3, 0.4 | etc. (i just put | for readability).
It seems useful. So far I have been using ROW for sequences with steps of 1 (1, 2, 3, 4, ...) but I struggled to figure out how to do things by for example 2 steps at once (1, 3, 5 ,6, or 1, 1, 2, 2, 3, 3....). Seems like I can at least use this for those cases.
You may try this
=Scan(0,ArrayFormula(sequence(8,1,1)/10),lambda(cum,curr,cum&" "&curr))
Kind Regards
thanks a lot this is exactly what im looking for..New subscriber here 👍
Thank you Very Much
Still struggling to make a sequence with leading 0, 01~09 then 10 11 12 just by tyoing the number, =sequence('10) didn't work...
Brilliant
Thank you!
G'day and thank you for your video. I've been searching left and right for the following solution - THANK YOU FOR ANY HELP YOU COULD PROVIDE :)
I need a dynamic sequence for each prospect I enter in my Google Sheet
AA-0000 whereas the 2 Letters will move to the next logical letter after 9999, as follow:
AA-0001, AA-0002, AA-0003... AA-9999
> AB-0001, AB-0002, AB-0003... AB-9999
> AC-0001...
Once AZ-9999 comes around, we continue with the next logical letter:
AZ-9999 > BA-0001, BA-0002, BA-9999
> BB-0001, BB-0002, BB-0003
i got case here, i want make serial number with multi criteria such as this: A B B A C B A B, and i want A1 B1 B2 A2 C1 B3 A3 B4, repeated sequence with criteria A B C
Wow, I got confused!
I hpe you figured it out!
Regards,
@@practicalsheets i did it with your guide, thanks