• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding a U or D or a E or O next to each number

Is it possible to write a Macro or formula that will automatically place a E or O or a U or D next to my counters? I go through 1 at a time to verify it did what it was suppose to and compare them to the others. I attached a sheet but how it works is if it changes from a 1 to a 2 it would be a E or U if it was in columns CD JK QR XY AE AF AL AM AS AT AZ BA BG BH BN BO BU BV CB CC CI CJ CP CQ and then O or D if it was in coulumns EF LM ST Z AA AG AH AN AO AU AV BB BC BI BJ BP BQ BW BX CD CE CK CL CR CS .

please tell me how to write it as I do not expect you do it for me I like learning although I know to a point you have to do it to show me I guess . I will copy and paste the counters on a separate sheet the attached an always in the same rows and columns. They always count up and go to a 1 after a 9. Hope this makes sense
 

Attachments

  • Even-Odd.xlsx
    43.3 KB · Views: 3
Back
Top