damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
OK, my last one for today...
I've searched the net for help to this one but I've only found answers that are for the text in the cell furthest to the right of a range of cells rather than form certain cells......
Anyway, in cell E8 I need it to show the value in the furthest to the right of the cells M8, W8, AG8 & AQ8 (all of the ones I've coloured in yellow in the screenshot below) - so in this instance E8 would need to show the value from W8 which in this case is P02.
However, I cant get this to work whatsoever and I think that is because the formulas that I have found are when it needs to look at a range of cells rather that every 10th cell along the row AND because the value in cells M8, W8, AG8 & AQ8 is actually the result of a formula - I've included in row 9 all of the formulas that occur in row 8 just in case that helps with helping me.
Now ideally (and also greedily), the formula in cell E8 would be smart enough to take advantage of the fact that the cells it needs to look in are regularly spaced out at every 10 columns.
Anyway, as usual all help would be appreciated.
I've searched the net for help to this one but I've only found answers that are for the text in the cell furthest to the right of a range of cells rather than form certain cells......
Anyway, in cell E8 I need it to show the value in the furthest to the right of the cells M8, W8, AG8 & AQ8 (all of the ones I've coloured in yellow in the screenshot below) - so in this instance E8 would need to show the value from W8 which in this case is P02.
However, I cant get this to work whatsoever and I think that is because the formulas that I have found are when it needs to look at a range of cells rather that every 10th cell along the row AND because the value in cells M8, W8, AG8 & AQ8 is actually the result of a formula - I've included in row 9 all of the formulas that occur in row 8 just in case that helps with helping me.
Now ideally (and also greedily), the formula in cell E8 would be smart enough to take advantage of the fact that the cells it needs to look in are regularly spaced out at every 10 columns.
Anyway, as usual all help would be appreciated.