+ Reply to Thread
Results 1 to 30 of 30

Formula must reference same cells after those cells are shuffled [Google Sheets]

  1. #1
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Formula must reference same cells after those cells are shuffled [Google Sheets]

    Hey Everyone. Take a look at this pic (Hope this works).

    Column A is a formula for Columns B:D. When I randomize A:D, my results yield what you see in F:J (Just ignore Column G as I inserted it stricly for aesthetic reasons after the randomization. But what I really want in Column F is what you see in Column L. I want the formulas to point to their original cell contents no matter where they are randomized to. Anyone have any idea how to do this? I've tried $ signs in front of them, I've tried different cell randomization to no avail. Anybody? I sure could use some help on this. I've racked my brain for hours and hours. I don't even know what to search for to ask the right questions. Please help. Thank you.

    Spreadsheet Sample.jpg
    Last edited by 6StringJazzer; 05-12-2022 at 10:15 PM. Reason: Moved from Excel Formulas & Functions

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,637

    Re: Can you figure this out?????

    We have a couple of problems here.

    First, your title doesn't tell us anything about your question. That could be the title of any post here. After I figure out what you are actually asking I will help you update your title, since it is your first post.

    Now then. It is not at all clear what logic you are applying to get the "desired" result. What do you mean in this case by "randomization"? What exactly did you do to get to the "Formula After Randomization" version? How are you determining what rows have the formulas in the "Desired" version? How you are determining what those formulas should be?

    We can't tell you how to do something in absence of a description of what to do. It would probably help if you give us the big picture and explain what this data means and what you are trying to do.

    Also I can't see the utility of formulas that all sum blank cells, but let's not worry about that just yet.

    Oh, also, do make the effort to tell us your Office version. Some functions and features in later versions are not available in earlier versions. We don't want to give you a solution that you can't use.

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    I'll help you once we sort out what your question is.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,542

    Re: Can you figure this out?????

    Administrative Note:

    MS-Off Ver: Unspecified
    Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


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


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  4. #4
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Can you figure this out?????

    We have a couple of problems here.

    ...First, your title doesn't tell us anything about your question. That could be the title of any post here. After I figure out what you are actually asking I will help you update your title, since it is your first post If I actually knew what question to ask, I would have put it in the title. I explicitly said ...I don't even know what to search for to ask the right questions So if you know what question I need to ask, by all means, Im all ears.

    I have several hundred rows. I gave you nine of them. The data in every three rows goes together (i.e. the value of 1,101, 201 go together, 2,102,202 go together, 3,103,203 go together, and so forth and so on) Those are all in column B. I cant give you specifics about each of the ITEMS (A through I) as that is proprietary content. Because the entry is taking place by individuals in close proximity to one another, we want to randomize the data and checkpoints in Column D so that no one can look at someone elses computer adjacent to them, and copy their answers to prevent cheating.

    My humble apologies, as I omitted what lies in column E. That was an oversight. It is a simple formula of E4=if(D4,4,); then E5=if(D5,2,); then E6=if(D6,1,); and then copied and repeats itself for the remaining rows every three rows in the spreadsheet.

    As long as I dont randomize it, no problem. But when I do, I want the calculation in column F to continue to track and calculate based on 1 and ITEM A, 101 and ITEM B, and, 201 and ITEM C respectively no matter what row they happen to land in after the randomization. For example, if they end up in Rows 19, 237, and 4, respectively, I want it to do the calculations E19=if(D19,4,); E237=if(D237,2,); and E4=if(D4,1,). Then when it does the final calculation in Column F, for these three items, it would be F19=E19+E237+E4. Thats what Im trying to get it to do. Incidentally, I dont really care where it does that calculation in Column F as long as it keeps the three together to make the calculation.

    Im not doing this one in Excel because many who are taking this test dont have OFFICE. Therefore, Im deliberately doing this spreadsheet in Google Sheets because everybody has access to it regardless of whether they have Excel or not. Im not going to make Excel a mandatory requirement for them to take it. So it is independent of Microsoft Office, but I want to be able to import it into OFFICE for those who do have it.

    Feel free to amend the title to better reflect what you think it should be. I dont know. If I did, I would be happy to amend it.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,637

    Re: Can you figure this out?????

    Quote Originally Posted by SpreadSpectrum View Post
    no one can look at someone elses computer adjacent to them, and copy their answers
    So these are some sort of questions? And people answer them? Is this like multiple choice with three options for each question? (I would have put all three choices in one row, instead of three rows. I think that is part of what is giving you a headache.)

    Quote Originally Posted by SpreadSpectrum View Post
    Im deliberately doing this spreadsheet in Google Sheets
    Well, we're going to have to move it to another subforum then. This one is strictly for Excel, and the answer in Google could be quite different.

    As to the title, I think you want formulas to continue to reference the same cells even after those cells have been moved around. But the one last thing I would like to know is how are you randomizing it?

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,637

    Re: Can you figure this out????? [Google Sheets]

    I think I may have enough to figure this out. I assume your numbers in column B are real, and you do not have more than 300 rows. Put this formula in A4 and copy down:

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


    This is an Excel formula but I think it will work in Google Sheets.
    Last edited by 6StringJazzer; 05-12-2022 at 10:20 PM. Reason: Inequality was going the wrong way, correction in red

  7. #7
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    ...So these are some sort of questions? And people answer them? Is this like multiple choice with three options for each question? (I would have put all three choices in one row, instead of three rows. I think that is part of what is giving you a headache.)...

    No, they are not multiple choice. You can select none or up to all three, so there are a total of 8 possibilities (think binaryhence 4,2,1, and of course 0) to add up to a range between 0-7.

    ...As to the title, I think you want formulas to continue to reference the same cells even after those cells have been moved around. But the one last thing I would like to know is how are you randomizing it?...

    Its a Menu selection. Just select the range you want to randomize, and then Menu=>Data=>Randomize Range. Each person is given a different randomized spreadsheet to answer just for them.

    Your formula ...=IF(B4>=100,"",E4 + INDEX(E:E,MATCH(B4+100,B:B,0)) + INDEX(E:E,MATCH(B4+200,B:B,0))...? It works perfectly for the first three, but doesnt for the next three, and yet changes again for the next three. But these are some functions Ive never needed to use before, but you may be on the right track. Let me play with it a little bit and see what I can figure out. Thanks for that BTW.

  8. #8
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,637

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Quote Originally Posted by SpreadSpectrum View Post
    Your formula ...=IF(B4>=100,"",E4 + INDEX(E:E,MATCH(B4+100,B:B,0)) + INDEX(E:E,MATCH(B4+200,B:B,0))...? It works perfectly for the first three, but doesnt for the next three, and yet changes again for the next three. But these are some functions Ive never needed to use before, but you may be on the right track. Let me play with it a little bit and see what I can figure out. Thanks for that BTW.
    Are you putting in the formula before randomizing, or after? If you provide a link to your test file in Google Sheets, this will go a bit faster. I can't test a formula on a picture.

    I do not believe there is a corresponding function in Excel for randomizing data, so I did not realize that was available. I'll look into that in Google Sheets.

  9. #9
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    im curious if you have considered to use Google Forms to create a quiz, which has features to randomize questions and answers?

    although each option wont be grouped, you could use formulas on the results (which will be correctly sorted) to then calculate the formula accuracy.

    furthermore, Google Forms has capacity to mark the tests for you.

    https://support.google.com/a/users/answer/9308764?hl=en
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  10. #10
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    One method to achieve what you want...

    You can "lock the E cell references" by using column B as SUMIF criteria... of course you can also use columns C instead, however, as the formulas are self explanatory i wont be writing all the different changes you might like to try.

    as an example:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    So how many posts must I make in order to attach a link to my Google Sheet? This forum has prohibited me from including a link.

  12. #12
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    the minimum posts for links is 10, but attaching files (following the method in yellow banner above) is immediately available.

    if you post the link with (dot) instead of .
    and (slash) instead of /
    then the mods can fix it back to a valid link for you.

  13. #13
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    I've edited it multiple times now, and it still thinks it's a link. This is post #5. Guess I'll post 5 more times just to get my link out there.

  14. #14
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    I tried what you said janmorris, and it still produced an error message.

  15. #15
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    send it to me in a message, and i will post it for you

    or... if we just chat here a couple more times then we reach the 10 post goal.. yay! haha

  16. #16
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    I guess I assumed it would place a copy automatically into my Sent folder, but apparently not unless I explicitly tell it to. I sent you the link, so I hope you got it janmorris. Thanks so much.

  17. #17
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    hi @SpreadSpectrum

    sorry for the delay, i was on remote island for the week, just got back to civilisation.

    here is the link for your file:

    https://docs.google.com/spreadsheets...gid=1353904934

  18. #18
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    i have entered in the first 3 variations of the formulas into column I.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    note the changing numbers from column C.

    if column D were all unique items then you could use those instead (while also changing the formula cell references from $C$6:$C$306 to $D$6:$D$306)

    now, you just need to copy and paste those formulas down further and make the necessary changes where i highlighted in blue.

    EDIT:

    the formulas in column I will do what is expected, but i see that you will still have the problem of column G not keeping the required cell references that will be added together.

    to fix that, you will need a lookup (or index match) formula written specifically for each and every row (cell) of column G.
    Last edited by janmorris; 05-20-2022 at 12:04 PM.

  19. #19
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    "the formulas in column I will do what is expected, but i see that you will still have the problem of column G not keeping the required cell references that will be added together."

    Actually, it is tracking quite nicely. So wherever C6 moved to, so too did G6 where it is looking up F6 for the result. So I don't have a problem with that it seems.

    Incidentally, this in Column I: =SUMIF($C$6:$C$305,1,$G$6:$G$305)+SUMIF($C$6:$C$305,101,$G$6:$G$305)+SUMIF($C$6:$C$305,201,$G$6:$G$305) is yielding the exact same result as this in Column H: =IF(OR(C6<=0,C6>100),,G6+INDEX(G:G,MATCH(C6+100,C:C,0))+INDEX(G:G,MATCH(C6+200,C:C,0))) even when randomized. So from my viewpoint, either one would work. Am I missing something?

    Now what I need is everything down below, (ie. D315 for example), I need to concatenate everything that equals a value of 3 which is binary 0x011 meaning there are two items which make up each entry that equals a 3. Same for D311, D313, D317, D319, D321, and D323. Any ideas on that one?

  20. #20
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Oh, and thank you for posting the linke!

  21. #21
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    if i randomize the range C6:F14, the values in H and I give incorrect values... where A + AA + AAA should equal 7, it is not.

    but if it is working for you then thats ok.

    ooohhh. i see now.. when you randomize the range C6:G14, then it works.. no problem
    Last edited by janmorris; 05-20-2022 at 04:07 PM.

  22. #22
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Now what I need is everything down below, (ie. D315 for example), I need to concatenate everything that equals a value of 3 which is binary 0x011 meaning there are two items which make up each entry that equals a 3. Same for D311, D313, D317, D319, D321, and D323.
    are the current concatenations how they should appear? or do you need then to look different somehow?
    if different, can you manually create how you want each to look based on the current data, and then i will take a look how i can recreate with formula.

  23. #23
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    OK,

    Columns I & H yield the exact same results. The only difference is that Column I is unlocked and Column H is locked and protected with $ signs. Either will work I think in this case. However, whichever one works best for filling in D311D323 correctly is what I need to finish this. I know I can figure it outI just dont have the time to dredge through it if someone knows a quick down and dirty way to yield the results that I want. I am most grateful for your help.

    About D11D323. Here is what the results should yield given the current boxes that are checked checked in Column F:

    Row 311EMPTY. There is no value of 1 calculated.
    Row 313⬜ ITEM CC
    Row 315EMPTY, There is no value of 3 calculated.
    Row 317⬜ ITEM BBB
    Row 319EMPTY, There is no value of 5 calculated.
    Row 321EMPTY, There is no value of 6 calculated.
    Row 323⬜ ITEM A AND ITEM AA AND ITEM AAA.

    In summary, using [XYZ] as an example, we have [XYZ], [XYZXYZ], and [XYZXYZXYZ] as the three possibilities for any given trio of ITEMS.

    If Column H or Column I = 1, then we simply have Row 311 with ⬜ [XYZ] and nowhere else for [XYZ].
    If Column H or Column I = 2, then we simply have Row 313 with ⬜ [XYZXYZ] and nowhere else for [XYZ].
    If Column H or Column I = 3, then we simply have Row 315 with ⬜ [XYZ] AND [XYZXYZ] and nowhere else for [XYZ].
    If Column H or Column I = 4, then we simply have Row 317 with ⬜ [XYZXYZXYZ] and nowhere else for [XYZ].
    If Column H or Column I = 5, then we simply have Row 319 with ⬜ [XYZXYZXYZ] AND [XYZ] and nowhere else for [XYZ].
    If Column H or Column I = 6, then we simply have Row 321 with ⬜ [XYZXYZXYZ] AND [XYZXYZ] and nowhere else for [XYZ].
    If Column H or Column I = 7, then we simply have Row 323 with ⬜ [XYZXYZXYZ] AND [XYZXYZ] AND [XYZ] and nowhere else for [XYZ].

    Since Columns H & I yield the same results, it should be irrelevant which one we use.

    I hope that all makes sense. If you think of it in binary terms, [XYZ] = 1, [XYZXYZ] = 2, and [XYZXYZXYZ] = 4.

    NONE = 0
    [XYZ] = 1
    [XYZXYZ] = 2
    [XYZ] + [XYZXYZ] = 3
    [XYZXYZXYZ] = 4
    [XYZXYZXYZ] + [XYZ] = 5
    [XYZXYZXYZ] + [XYZXYZ] = 6
    [XYZXYZXYZ] + [XYZXYZ] + [XYZ] = 7

    You get the idea. Hope this helps clear up any confusion. Its kinda hard to explain.

    Thanks again for your help and feedback.

  24. #24
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Haven't figured this editing thing out for the forum yet. I forgot to add, I hid Rows 16...305. I don't have any boxes checked below Item C, in Column F, so it wouldn't yield any results in the aforementioned Rows below.

  25. #25
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Hi SpreadSpectrum,

    ive been trying to understand what you want to be in cells D311 down...

    for example it says if value of 1 then put that item, if value of 2 then put that item...
    but currently for value of 2 for it shows CCC, but i thought it should be CC

    can you please confirm what the values should be by manually placing A,AA,AAA,B,BB,BBB,C,CC,CCC into cells G311 and down.

  26. #26
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Thanks. I took out the concatenate statements and put in verbatim what it should look like whether Rows 6..305 are randomized or not. If the boxes are checked in Column F regardless of where they appear, the results should not change randomized or not. Hope that helps.

  27. #27
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    Great, that helps a lots.

    My analysis of what i see happening...

    Where column H shows a 7 (next to ITEM A), it means that all 3 items for the group (1, 101, 201) have been selected, and therefor you want that group concatenated, and also any other group that has the 7.

    Similarly, where H shows 4 (next to ITEM B), it means that only the last item of the group (202) has been selected, and therefor you want that item concatenated, and also any other item that has the 4.

    So, taking this further, if it was 6, then we want the 2nd and 3rd items of each group where there is a 6.
    And 1st and 3rd items of each group where there is a 5..
    And so on and so forth.

    Is that correct?

    If so, do you want just 1 grey square at the start of the concatenation, or do you want a grey square at the start of every concatenated set?
    so for example do you want:
    ⬜ Item A and Item AA and Item AAA and Item X and Item XX and Item XXX
    or do you want:
    ⬜ Item A and Item AA and Item AAA ⬜ Item X and Item XX and Item XXX
    or something else?

    Sorry for asking these questions, i just want to make sure i understand this clearly.
    Last edited by janmorris; Yesterday at 05:13 AM.

  28. #28
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    "...Is that correct?..."

    YES

    This how I want it to look.

    "...
    ⬜ Item A
    AND
    Item AA
    AND
    Item AAA
    [A LINE SPACE BETWEEN THEM, BUT NOT NECESSARY HERE]
    ⬜ Item X
    AND
    Item XX
    AND
    Item XXX
    ..."

    I hope that makes sense. Please don't apologize for asking questions. The only stupid ones are the ones left unasked.

  29. #29
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    764

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    I just want to give you update that i havent left this problem.

    i expanded the range to be A-F, this gives me a better visual of the problem, and how i can attack it.

    i have extended the column I formulas to cover A-F (1-6).

    it looks like the column H formulas arent properly tracking the randomisation.

    anyhows, i just wanted to let you know im still working on it.

  30. #30
    Registered User
    Join Date
    05-11-2022
    Location
    USA
    MS-Off Ver
    Unspecified
    Posts
    14

    Re: Formula must reference same cells after those cells are shuffled [Google Sheets]

    That's fine. I appreciate all the help I can get on it. Conceptually, I know what I want it to do. I just can't figure out a way to do it without complicating it so.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  2. (Google App Scripts) Copy and paste value for all Google Sheets contained in one folder
    By bobbiekan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-29-2021, 11:48 PM
  3. Replies: 0
    Last Post: 01-30-2021, 05:44 AM
  4. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. Google Sheets: Formula to figure out distance from target
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-14-2018, 09:41 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

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