nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Is there a formula that will allow me to select the far most value to the right of a row? Also, the value should only be selected if it appears under the day of the month - 1. (yesterday)
For example, in the top table below the value to the far right = 10 This will be returned in to my result cell as the value does sit under yesterdays day of the month.
In the second example the cell = blank on yesterdays day of month and therefore the result in my result cell will = 0.
I hope this makes sense.....
For example, in the top table below the value to the far right = 10 This will be returned in to my result cell as the value does sit under yesterdays day of the month.
In the second example the cell = blank on yesterdays day of month and therefore the result in my result cell will = 0.
I hope this makes sense.....
Book10 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | |||
6 | Result | 10 | ||||||||||||||||||||||||||||||||
7 | ||||||||||||||||||||||||||||||||||
8 | Day of month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | ||
9 | Value | 70 | 61 | 91 | 21 | 73 | 72 | 67 | 116 | 61 | 88 | 103 | 100 | 85 | 69 | 5 | 92 | 107 | 100 | 76 | 62 | 12 | 10 | |||||||||||
Sheet1 |
Book10 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | |||
14 | Result | 0 | ||||||||||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||||||||||
16 | Day of month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | ||
17 | Value | 70 | 61 | 91 | 21 | 73 | 72 | 67 | 116 | 61 | 88 | 103 | 100 | 85 | 69 | 5 | 92 | 107 | 100 | 76 | 62 | 12 | ||||||||||||
Sheet1 |