About 1,007,373 results (4,864 milliseconds)
I cannot get Google Sheets to autofill a column with sequential ...
https://support.google.com/docs/thread/206551466/i-cannot-get-google-sheets-to-autofill-a-column-with-sequential-numbering?hl=en Mar 17, 2023 ... To learn more about the "SEQUENCE function" search for it in your browser or on YouTube. You can also look at the EXCEL results as it works the ...
How to create a sequence of dates every seven days - Google Docs ...
https://support.google.com/docs/thread/99018807/how-to-create-a-sequence-of-dates-every-seven-days?hl=en Feb 21, 2021 ... Hi! I'm creating a weekly schedule, and trying to find a formula to return the date for every Saturday of this year.
Number sequencing does not work if there is a merged cell included ...
https://support.google.com/docs/thread/198238958/number-sequencing-does-not-work-if-there-is-a-merged-cell-included?hl=en Jan 20, 2023 ... I was able to have a macro in Excel which was able to do this: ... Enter the SEQUENCE function in the helper column;. =SEQUENCE(ROWS(C2 ...
Excel export ARRAYFORMULA stopped working - Google Docs ...
https://support.google.com/docs/thread/79558269/excel-export-arrayformula-stopped-working?hl=en Oct 28, 2020 ... Your screenshot shows that the simple sequence formula has been converted into a {Microsoft Excel arrayformula}, while my understanding is that ...
SEQUENCE function - Google Docs Editors Help
https://support.google.com/docs/answer/9368244?hl=en The SEQUENCE function returns an array of sequential numbers, such as 1, 2, 3, 4. Parts of a SEQUENCE function SEQUENCE(rows, columns, start, step)
Array Result was not expanded Error when using SEQUNCE ...
https://support.google.com/docs/thread/105687651/array-result-was-not-expanded-error-when-using-sequnce-function-in-google-spread-sheet?hl=en Apr 10, 2021 ... Like this I've to do for the entire excel file (ie in this example I've to repeat the procedure up to 22). I used the SEQUENCE function. It ...
Fill down in Series not working? - Google Docs Editors Community
https://support.google.com/docs/thread/202253546/fill-down-in-series-not-working?hl=en Feb 16, 2023 ... I love the fill down options on Excel but frustrating when they don't work. ... It does depend on the values, or formula, you may be starting off ...
how to create time slots with regular intervals? - Google Docs ...
https://support.google.com/docs/thread/94959231/how-to-create-time-slots-with-regular-intervals?hl=en Jan 24, 2021 ... User fills in values in those purple cells. Formula in B4 is primary engine: ={"Slot Start";. Arrayformula(C1+(Sequence(Int(( ...
What is the equivalence of Copy, Ctrl + Shift + Down, Enter in Sheets ...
https://support.google.com/docs/thread/117768960/what-is-the-equivalence-of-copy-ctrl-shift-down-enter-in-sheets?hl=en Jul 19, 2021 ... In Excel, It's Copy, then Ctrl + Shift + Down, and Enter to fill the ... =arrayformula( iferror( sequence(7) / ( (sequence(7) <= 3) + ...
Create autofill number sequence that works with row insert - Google ...
https://support.google.com/docs/thread/6240405/create-autofill-number-sequence-that-works-with-row-insert?hl=en May 16, 2019 ... ... sequence. So while I could go by the default ... why do we have to use a formula to just do a simple fill series? Isnt this excel ....
How to get repeatable Excel RAND sequence?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/YY-CJoiPc1M Mar 21, 2010 ... subsequent calls to RAND result in a repeatable sequence? I have tried seeding the VBA Rnd function, to no avail. No surprise that the two are ...
Google Sheets Sequence Function. Decimal step value returns an ...
https://support.google.com/docs/thread/105460414/google-sheets-sequence-function-decimal-step-value-returns-an-incorrect-sequence?hl=en Apr 8, 2021 ... I am using the formula =SEQUENCE(21,1,-1,0.3) to try and create a sequence starting at -1 and differing by 0.3 each time.
Date Sequence and Time Sequence - Google Docs Editors ...
https://support.google.com/docs/thread/157510976/date-sequence-and-time-sequence?hl=en Mar 28, 2022 ... Can't see your sheet but this will give 365 24-hour days. =ArrayFormula(date(2022, 4, 1) +. floor(sequence(365*24, 1 ...
Proper Use of SEQUENCE and ARRAYFORMULA in a Dynamic List ...
https://support.google.com/docs/thread/236821840/proper-use-of-sequence-and-arrayformula-in-a-dynamic-list?hl=en Sep 27, 2023 ... On the columns where SEQUENCE & ARRAYFORMULA successfully work (Columns A,C), they reach the correct number of rows based on cell C2 (No. of ...
Excluding weekends on Google sheets gantt chart using conditional ...
https://support.google.com/docs/thread/112261044/excluding-weekends-on-google-sheets-gantt-chart-using-conditional-formatting?hl=en Jun 3, 2021 ... I have managed to do it on excel, but Google sheets seems to be abit more tricky. ... SEQUENCE formula, in I4. =SEQUENCE(1,35,$G$2-WEEKDAY(G2,3)+( ...
Count Last Sequence: Excel formula doesn't work in Google sheets ...
https://support.google.com/docs/thread/16790847/count-last-sequence-excel-formula-doesn-t-work-in-google-sheets?hl=en Oct 14, 2019 ... Count Last Sequence: Excel formula doesn't work in Google sheets · The first formula won't work in Sheets because AGGREGATE is not a supported ...
Formula for a sequence for a column - sequence should be 1a, 1b ...
https://support.google.com/docs/thread/189643020/formula-for-a-sequence-for-a-column-sequence-should-be-1a-1b-2a-2b-350a-350b?hl=en Nov 21, 2022 ... Formula for a sequence for a column - sequence should be 1a, 1b, 2a, 2b,...350a, 350b. This is the sequence I am trying to create: I tried ...
Array Formula for Sequence of Dates - Google Docs Editors ...
https://support.google.com/docs/thread/175871841/array-formula-for-sequence-of-dates?hl=en Aug 19, 2022 ... The problem I have is that I can't use an array with the sequence function at all and I was wondering if there was something I could do. Any ...
How can I use a formula to split a hyphenated number range and ...
https://support.google.com/docs/thread/56683630/how-can-i-use-a-formula-to-split-a-hyphenated-number-range-and-then-create-a-sequence-out-of-it?hl=en Jul 2, 2020 ... Hi all! Let's say I've got a cell containing the sequence `10-23`. I want to turn this into a column ...
Automatizing the creation of hybrid sequence codes in non-adjacent ...
https://support.google.com/docs/thread/113557819/automatizing-the-creation-of-hybrid-sequence-codes-in-non-adjacent-cells?hl=en Jun 14, 2021 ... this is the excel ... There are several ways of generating the codes, such as using the SEQUENCE function, or even the row number, to generate the ...