Excel Jeanie

Reply #4

frenchie — Tue, 31 Jan 2012 05:06:19 GMT

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

A B C D E F G H

1 1 to 28 29 to 56

2

3 10 19 24 37 44 3 2

4 24 29 37 48 50 1 4

5 1 5 15 22 28 5 0

6 2 9 30 37 42 2 3

7

Spreadsheet Formulas

Cell Formula

G3 =SUMPRODUCT(--(A3:E3 =1),--(A3:E3 =28))

H3 =SUMPRODUCT(--(A3:E3 =2... [ More ]

Reply #3

frenchie — Sun, 29 Jan 2012 18:22:04 GMT

Thank you Todd.

Reply #2

Todd — Fri, 20 Jan 2012 17:57:31 GMT

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... [ More ]

Reply #1

frenchie — Fri, 20 Jan 2012 17:38:31 GMT

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.

Excel Jeanie

frenchie — Sat, 24 Dec 2011 05:34:38 GMT

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.