+ Reply to Thread
Results 1 to 23 of 23

Google sheet formula required.

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Google sheet formula required.

    Hi Friends,
    i have formula =sequence(1, 7, c11, 1) to get the date in sequence for the next 7 days,

    but i need a modification on it... A blank required between each cell as shown below.

    attaching the sample spread for reference

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    Before we proceed with this, please update your forum profile as I requested in your previous thread.

    Please also review the forum guidelines on thread titles, which should not be generic.

    Finally, for GS queries, you need to provide a LINK to an editable GoogleSheet, not an Excel file.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Re: Google sheet formula required.

    Hi Mam,
    Changed the profile name to Google sheets and adding a link of google sheet here:
    https://docs.google.com/spreadsheets...it?usp=sharing

    Please help me on it
    Last edited by amb2301; 06-15-2024 at 02:33 AM.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    Thanks - your thread title ought to be improved.

    I can't help - sorry. Someone who uses GS will. Please be patient and remember it's a weekend, so footfall here is lower.

  5. #5
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Re: Google sheet formula required.

    I understand mam as you said footfall will be lower during weekends,
    if you could please help me with Excel formula it would be a great help for me as the same can be applied over GS.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    You have ignored my comments about the thread title, which remains generic. You will most likely get better responses if the thread title describes the problem.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    In Excel 365:

    =LET(s,SEQUENCE(1,7,C11,1),e,IF(s<>"","",""),TOROW(VSTACK(s,e),0,1))

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    Your GS is View Only - you need to provide write access.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    For GS:

    =ARRAYFORMULA(LET(s,SEQUENCE(1,7,C11,1),e,IF(s<>"","",""),TOROW(VSTACK(s,e),0,1)))

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,124

    Re: Google sheet formula required.

    Slight variation on the mechanism to get the blank cells in Ali's formula*, and slightly shorter.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    * Learning lots today 👍
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    That's a nice trick - I'll be pinching that one!

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Google sheet formula required.

    If we're playing the "Mine's shorter than yours" game:

    =LET(s,SEQUENCE(,7,C11),TOROW(VSTACK(s,T(+s)),,1))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    Nice and compact.

    What else can one do on a cold, wet and windy summer's day (feels more like autumn)?

    EDIT: Would be nice if the OP would bother to acknowledge these suggestions, all of which they've seen.
    Last edited by AliGW; 06-15-2024 at 06:56 AM.

  14. #14
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Google sheet formula required.

    I'm on the Crozon peninsula, in Brittany... freezing cold, windy and tipping it down outside.

  15. #15
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,124

    Re: Google sheet formula required.

    Well, you don't need to go to Brittany to get that. Staying at home trying to stop the squirrels getting onto the bird feeders.

    If we're playing the "Mine's shorter than yours" game:
    Guessing not a phrase you'll hear often. But, no, that wasn't the specific intent. Just exploring options (primarily because an IF that could only return null values seemed an odd construct).

  16. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    because an IF that could only return null values seemed an odd construct
    But it did the job, albeit not as elegantly as T(+s)!!!

  17. #17
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Re: Google sheet formula required.

    Thank you so much Mam for your prompt response
    and its working absolutely fine !!!

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Google sheet formula required.

    Please don't forget the other contributors!

  19. #19
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Re: Google sheet formula required.

    Thank you all and appreciate each of you; your actions have made my day so much better.

  20. #20
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,124

    Re: Google sheet formula required.

    But it did the job, albeit not as elegantly as T(+s)!!!
    Well, we now have three ways to do the job. Always good to have options . Good working with you

  21. #21
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Google sheet formula required.

    You're welcome. Thanks for letting us know that you got an answer.




    Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

  22. #22
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    Google sheets
    Posts
    209

    Re: Google sheet formula required.

    Hi Glenn, Thank you so much for your help,
    Its done now

  23. #23
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,124

    Re: Google sheet formula required.

    Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-16-2024, 04:44 AM
  2. How to auto update master google sheet tracker from two different google sheets
    By maheshmethal in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 05-10-2024, 06:00 AM
  3. Google SHeets: Count Checked checkboxes in filtered data of google sheet
    By Faizan Naseem in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-07-2022, 05:42 AM
  4. Google Sheets formula for bringing in checkbox info from sheet B to sheet A
    By wolverineandrew in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-14-2022, 08:00 AM
  5. Replies: 0
    Last Post: 02-13-2022, 05:51 PM
  6. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  7. [SOLVED] Google Sheets: Formula Required For Look Up Value
    By sijostephen in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 07-01-2019, 04:39 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1