<div>
<div class="content wysiwyg-content">
I have a file that looks like<br />
<br />
Jan Feb Mar April May June<br />
12 &nbsp; 23 &nbsp; 45 &nbsp; &nbsp;67 &nbsp; 34 &nbsp; &nbsp; #N/A<br />
<br />
I want to be able to have a formula that returns the last month that is not #N/A, so in this case the formula would return May. &nbsp;<br />
<br />
Thanks<br />
Montrof
</div>
</div>


I have a file that looks like

Jan Feb Mar April May June
12   23   45    67   34     #N/A

I want to be able to have a formula that returns the last month that is not #N/A, so in this case the formula would return May.  

Thanks
Montrof

Select last month in Row

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.