excel Help! | Lottery Post

excel Help! | Lottery Post

Hi everybody,

I would like assist and/or steering for an excel sheet. I did a seek and did not to find anything else as regards to what I used to be in search of!

Below is an instance of the way my excel sheet is ready up! I am attempting to determine a solution to routinely get the result of (the usage of Sun and Mon as anchor for every week and the next days together with the following Sun and Mon, then beginning with the present solar and mon. The effects could be “S” for similar, “-1” for one digit under and +1 for one digit above! From the entire array (Sun and Mon numbers) with S taking Priority over the opposite two.


tue 952 returns *-1-1 from (solar and mon [603}

thu 756 returns S-1+1

Keep in thoughts the array of digits will trade from week to week (6 other to one[probably not]).


The effects could be from tue 17th to mon 23rd and the brand new anchor could be Sun and Mon 22nd and 23rd. I need this on a big workforce of previous attracts different sensible I will be able to input in by way of hand.


Wed five five 2
Tue-Oct-24-2017 Tue nine five eight
Mon-Oct-23-2017 Mon four zero 2
Sun-Oct-22-2017 Sun 2 nine 6
Sat-Oct-21-2017 Sat 7 four 2
Fri-Oct-20-2017 Fri 6 zero zero
Thu-Oct-19-2017 Thu 7 five 6
Wed-Oct-18-2017 Wed five 1 eight
Tue-Oct-17-2017 Tue nine five 2
Mon-Oct-16-2017 Mon 6 zero three
Sun-Oct-15-2017 Sun 6 6 three
Sat-Oct-14-2017 Sat three 6 five



Updated: February 19, 2018 — 11:38 pm

Leave a Reply

Your email address will not be published. Required fields are marked *