excel Help! | Lottery Post
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.