Welcome Guest
Log In | Register )
You last visited December 11, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Excel Jeanie

Topic closed. 4 replies. Last post 5 years ago by frenchie.

Page 1 of 1
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
Posted: December 24, 2011, 12:34 am - IP Logged

Hello Todd,

I was just wondering if you could introduce " Excel Jeanie " in your web site, to make it easier for us to show the Excel files when we need to ?

Regards.

Serge.

    frenchie's avatar - Lottery-041.jpg
    Los Angeles
    United States
    Member #75410
    June 2, 2009
    479 Posts
    Offline
    Posted: January 20, 2012, 12:38 pm - IP Logged

    Hello Todd,

    You haven't reply on this post !!!

    It's a very nice way to post your excel sheet display as well as the formulas and conditional formatting when someone need to ask a question.

      Todd's avatar - Cylon 2.gif
      Chief Bottle Washer
      New Jersey
      United States
      Member #1
      May 31, 2000
      23277 Posts
      Online
      Posted: January 20, 2012, 12:57 pm - IP Logged

      Have you tried using Lottery Post's built-in paste functions to insert Excel content?  I'm not sure another product is needed.

      If "regular paste" (pressing Ctrl+V on your keyboard) does not work well for your particular spreadsheet, try using the "Paste as Word document" button, which is designed to work with both Word and Excel content.

      If you'd like to do a test of pasting a sample Excel chart of yours on this thread, feel free.

      Another way to test something privately (rather than testing on the public forums and/or blogs) is to send yourself a private message (enter your own name as the recipient), and then paste your test content into the private message.  This is a nice way to test something, because it uses exactly the same text editor and back-end processing as forum posts use.

       

      Check the State Lottery Report Card
      What grade did your lottery earn?

       

      Sign the Petition for True Lottery Drawings
      Help eliminate computerized drawings!

        frenchie's avatar - Lottery-041.jpg
        Los Angeles
        United States
        Member #75410
        June 2, 2009
        479 Posts
        Offline
        Posted: January 29, 2012, 1:22 pm - IP Logged

        Thank you Todd.

          frenchie's avatar - Lottery-041.jpg
          Los Angeles
          United States
          Member #75410
          June 2, 2009
          479 Posts
          Offline
          Posted: January 31, 2012, 12:06 am - IP Logged

          Here is just a small example to show how Excel Jeanie display the Excel table.

          The Question was :

          I need a simple formula to count how many numbers are from 1 to 28 and 29 to 56.



          Sheet1

           ABCDEFGH
          1      1 to 2829 to 56
          2        
          31019243744 32
          42429374850 14
          515152228 50
          629303742 23
          7        

           

          Spreadsheet Formulas
          CellFormula
          G3=SUMPRODUCT(--(A3:E3>=1),--(A3:E3<=28))
          H3=SUMPRODUCT(--(A3:E3>=29),--(A3:E3<=56))



          Excel tables to the web >> Excel Jeanie HTML 4

           

          Regards.

          Serge.