Hi everyone,
I need help and/or guidance for an excel sheet. I did a search and didn't find anything close to what I was looking for!
Below is an example of how my excel sheet is set up! I'm trying to figure out a way to automatically get the results of (using Sun and Mon as anchor for each week and the following days including the next Sun and Mon, then starting with the current sun and mon. The results would be "S" for same, "-1" for one digit below and +1 for one digit above! From the whole array (Sun and Mon numbers) with S taking Priority over the other two.
Example
tue 952 returns *-1-1 from (sun and mon [603}
thu 756 returns S-1+1
Keep in mind the array of digits will change from week to week (6 different to 1[not likely]).
The results would be from tue 17th to mon 23rd and the new anchor would be Sun and Mon 22nd and 23rd. I want this on a large group of past draws other wise I can enter in by hand.
Wed-Oct-25-2017
|
Wed |
5 |
5 |
2 |
Tue-Oct-24-2017 |
Tue |
9 |
5 |
8 |
Mon-Oct-23-2017 |
Mon |
4 |
0 |
2 |
Sun-Oct-22-2017 |
Sun |
2 |
9 |
6 |
Sat-Oct-21-2017 |
Sat |
7 |
4 |
2 |
Fri-Oct-20-2017 |
Fri |
6 |
0 |
0 |
Thu-Oct-19-2017 |
Thu |
7 |
5 |
6 |
Wed-Oct-18-2017 |
Wed |
5 |
1 |
8 |
Tue-Oct-17-2017 |
Tue |
9 |
5 |
2 |
Mon-Oct-16-2017 |
Mon |
6 |
0 |
3 |
Sun-Oct-15-2017 |
Sun |
6 |
6 |
3 |
Sat-Oct-14-2017 |
Sat |
3 |
6 |
5 |
Thanks
Alchemist.