Create a dial effect with Excel columnHow can I merge contents of 2 cells into 1 and shift the remaining...

What's the point of deactivating Num Lock on login screens?

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Alternative to sending password over mail?

Revoked SSL certificate

What does it mean to describe someone as a butt steak?

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

What does the "remote control" for a QF-4 look like?

What would happen to a modern skyscraper if it rains micro blackholes?

Watching something be written to a file live with tail

What typically incentivizes a professor to change jobs to a lower ranking university?

Is it possible to do 50 km distance without any previous training?

infared filters v nd

Why does Kotter return in Welcome Back Kotter?

Is it inappropriate for a student to attend their mentor's dissertation defense?

Can a monk's single staff be considered dual wielded, as per the Dual Wielder feat?

Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?

What is the word for reserving something for yourself before others do?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

How much RAM could one put in a typical 80386 setup?

High voltage LED indicator 40-1000 VDC without additional power supply

What is a clear way to write a bar that has an extra beat?

RSA: Danger of using p to create q

LWC SFDX source push error TypeError: LWC1009: decl.moveTo is not a function

What doth I be?



Create a dial effect with Excel column


How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?Excel formula to count when value changes?How to create a dynamically updating variable in MS ExcelHow do you create an Excel table with row headers instead of column headers?Excel - How to return a list of values in one column if a value in another column meets certain criteriaIn Excel have a cell read specific text when two others equal a certain valueFind keywords in paragraphs of text (in Excel)Excel Pivot Table with Multiple IndexesIs there a way to mark/tag an excel cell?Excel: Grading Formula to Omit Certain Cells






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.



For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:



IMG:



I'm trying to crack a crypt for a class and this would make it much easier.



It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.










share|improve this question









New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

    – Yuriy F
    21 hours ago











  • If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

    – Yuriy F
    20 hours ago











  • Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

    – Niayesh Isky
    20 hours ago


















0















I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.



For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:



IMG:



I'm trying to crack a crypt for a class and this would make it much easier.



It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.










share|improve this question









New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

    – Yuriy F
    21 hours ago











  • If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

    – Yuriy F
    20 hours ago











  • Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

    – Niayesh Isky
    20 hours ago














0












0








0








I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.



For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:



IMG:



I'm trying to crack a crypt for a class and this would make it much easier.



It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.










share|improve this question









New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












I'm looking for a way to take a column of a small but arbitrary length and create a dial effect. I want to be able to shift a column down any amount, and then when the cells go over the set arbitrary amount for the cell contents to go back on top.



For illustration, see this picture of a dial lock. This is essentially what I'm trying to do:



IMG:



I'm trying to crack a crypt for a class and this would make it much easier.



It doesn't need to be in Excel. If there's a web app that can do that, it would be even better, however Excel has easy manipulation so it would be easiest to implement from scratch probably.







microsoft-excel






share|improve this question









New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 20 hours ago









karel

9,35493339




9,35493339






New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 21 hours ago









Yuriy FYuriy F

12




12




New contributor




Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Yuriy F is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.













  • So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

    – Yuriy F
    21 hours ago











  • If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

    – Yuriy F
    20 hours ago











  • Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

    – Niayesh Isky
    20 hours ago



















  • So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

    – Yuriy F
    21 hours ago











  • If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

    – Niayesh Isky
    21 hours ago













  • @NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

    – Yuriy F
    20 hours ago











  • Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

    – Niayesh Isky
    20 hours ago

















So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

– Niayesh Isky
21 hours ago







So are you looking for a function that simply rotates though the alphabet and goes back to A when it reaches Z, and for that function to be triggered by some sort of "shift amount" cell value? (Anyway, I'm sure there are plenty of Caesar cipher tools available online - why Excel? :) )

– Niayesh Isky
21 hours ago















@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

– Yuriy F
21 hours ago





@NiayeshIsky Yes but it isn't the alphabet meaning the values can be alphanumeric, numbers, or letters in random order... I guess a Caesar cipher would've been a better analogy

– Yuriy F
21 hours ago













If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

– Niayesh Isky
21 hours ago







If it is a Caesar cipher, even if it's alphanumeric, then this decoder may be easier and faster to use than making an Excel sheet (note that it has a ROT-18 function for alphanumeric ciphers).

– Niayesh Isky
21 hours ago















@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

– Yuriy F
20 hours ago





@NiayeshIsky it isn't a standard set... for example, one 'alphabet' or excel column could be "IAGDIORRAESEMCGMIIEDEOANS". Then there are 3 other such strings of equal length and I want to be able to move them each individually, like you would a lock (see pic above)

– Yuriy F
20 hours ago













Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

– Niayesh Isky
20 hours ago





Oh I see, you're describing a polyalphabetic cipher with changing character sets. That's doable in Excel, though a quick implementation won't be very pretty :)

– Niayesh Isky
20 hours ago










1 Answer
1






active

oldest

votes


















0














I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.



The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID. MOD will be used to make the looping effect.



Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.



Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).



In the first cell of the first dial column, put this formula :



=MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)



Then extend for as many columns as you want and as many rows as there are characters in A1.



How this works :





  • MID($A$1,<N>,1) will extract the Nth character from cell A1


  • C$1+ROW()-ROW($C$2) gets the position of the dial


  • 1+MOD(<P>,LEN($A$1)) loops the position to the first one if it is greater than the length of the string in A1


Example






share|improve this answer
























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });






    Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.










    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421691%2fcreate-a-dial-effect-with-excel-column%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.



    The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID. MOD will be used to make the looping effect.



    Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.



    Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).



    In the first cell of the first dial column, put this formula :



    =MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)



    Then extend for as many columns as you want and as many rows as there are characters in A1.



    How this works :





    • MID($A$1,<N>,1) will extract the Nth character from cell A1


    • C$1+ROW()-ROW($C$2) gets the position of the dial


    • 1+MOD(<P>,LEN($A$1)) loops the position to the first one if it is greater than the length of the string in A1


    Example






    share|improve this answer




























      0














      I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.



      The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID. MOD will be used to make the looping effect.



      Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.



      Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).



      In the first cell of the first dial column, put this formula :



      =MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)



      Then extend for as many columns as you want and as many rows as there are characters in A1.



      How this works :





      • MID($A$1,<N>,1) will extract the Nth character from cell A1


      • C$1+ROW()-ROW($C$2) gets the position of the dial


      • 1+MOD(<P>,LEN($A$1)) loops the position to the first one if it is greater than the length of the string in A1


      Example






      share|improve this answer


























        0












        0








        0







        I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.



        The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID. MOD will be used to make the looping effect.



        Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.



        Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).



        In the first cell of the first dial column, put this formula :



        =MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)



        Then extend for as many columns as you want and as many rows as there are characters in A1.



        How this works :





        • MID($A$1,<N>,1) will extract the Nth character from cell A1


        • C$1+ROW()-ROW($C$2) gets the position of the dial


        • 1+MOD(<P>,LEN($A$1)) loops the position to the first one if it is greater than the length of the string in A1


        Example






        share|improve this answer













        I will describe how to do the dial effect like the lock, if you want to crack a code you should follow the advice of commenters.



        The idea for this solution is to have your string of letters in one cell and each row of the dial will extract one letter with MID. MOD will be used to make the looping effect.



        Insert the string of letters in the cell A1, the other cells of the first row will be used to get the position of each column of the dial.



        Add spin buttons through the developer tab in the ribbon and link each one of them with one cell of the first row (you should have one for each column in your dial, I chose two in the example below).



        In the first cell of the first dial column, put this formula :



        =MID($A$1,1+MOD(C$1+ROW()-ROW($C$2),LEN($A$1)),1)



        Then extend for as many columns as you want and as many rows as there are characters in A1.



        How this works :





        • MID($A$1,<N>,1) will extract the Nth character from cell A1


        • C$1+ROW()-ROW($C$2) gets the position of the dial


        • 1+MOD(<P>,LEN($A$1)) loops the position to the first one if it is greater than the length of the string in A1


        Example







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 16 hours ago









        StormweakerStormweaker

        965




        965






















            Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.













            Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.












            Yuriy F is a new contributor. Be nice, and check out our Code of Conduct.
















            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1421691%2fcreate-a-dial-effect-with-excel-column%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

            Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

            Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...