Hi,
Try this array formula in cell D14 and copy the formula down to D25:Here are 2 things to note, however:
1. Your D18 value was B, but my formula returns C. If I understand what you are trying to do, C is actually the correct answer. If I am mistaken, please explain to me why B is the correct answer.
2. This is an array formula. To enter an array formula, you need to use Ctrl + Shift + Enter to enter the formula, not just Enter. If entered correctly, the formula will be surrounded by braces {} in the formula bar. Also, an array formula that is not entered as such will often result in an error or an incorrect value somewhere, so this may also make it obvious that the formula has not been entered correctly.
I have attached the workbook with the formulae in the yellow cells, so that you may see that it works at least in this small sample.
I hope this helps
Bookmarks