I thought attachments are not permitted for this mail list? Would an embedded link to my Drop Box work here? (I am new to Drop Box.) I'll place the dummy array in my DB, to start.
Regards, Vince Sent from my iPad > On Jun 1, 2016, at 00:22, James Plante <jimpla...@me.com> wrote: > > One way would be to export it to PDF, and send the PDF as an attachment. > > Jim > >> On May 31, 2016, at 8:15 PM, Vince <wa.two...@verizon.net> wrote: >> >> Ooops! Copy from AOO-Calc and Paste to Thunderbird 45.1.0 for the mail list >> did not go very well (my first attempt) with that array. >> >> >> If anyone is interested, is there a suggestion for how I could project the >> array properly for email list viewing? >> >> VinceB. >> >> >>> On 5/31/2016 8:04 PM, Vince wrote: >>> Hi Brian: >>> >>> I created a play-file that used the array shown below: >>> >>> >>> B C D >>> E >>> * */Week #/* */Game #1/* */Game #2 /* */Game #3/* >>> 8 >>> 9 1 141 137 >>> 135 >>> 10 2 97 135 >>> 134 >>> 11 3 193 172 >>> 138 >>> 12 4 151 185 >>> 125 >>> 13 5 197 127 >>> 186 >>> 14 6 153 138 137 >>> 15 7 158 188 134 >>> 16 8 132 150 132 >>> >>> Your suggested formula (=SUMPRODUCT($D$9:$F$16>100;$D$9:$F$16<129), with a >>> modified target range, results returned are: >>> >>> *<100* *1* >> >>> *100 thru 129* *2* >>> *130 thru 139* *10* >>> *140 thru 149* *1* >>> *150 thru 159* *3* >>> *160 thru 169* *0* >>> *170 thru 179* *1* >>> *180 thru 189* *3* >>> *190 thru 199* *3* >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >