<div>
Try using the small function where 2 is the second smallest. This looks at the data in A1 and B1and if they are equal it returns the second smallest from A1:A6, otherwise it returns 99.<br />
<br />
=IF(A1=B1,SMALL(A1:A6,2),9<wbr />9)
</div>


Try using the small function where 2 is the second smallest. This looks at the data in A1 and B1and if they are equal it returns the second smallest from A1:A6, otherwise it returns 99.

=IF(A1=B1,SMALL(A1:A6,2),99)

<div>
Thanks to Martin and Ejgil for your contribution.<br />
Your solution Ejgil is perfect<br />
Many thanks<br />
Ian
</div>


Thanks to Martin and Ejgil for your contribution.
Your solution Ejgil is perfect
Many thanks
Ian

<div>
<div class="content wysiwyg-content">
Hi,<br />
I would like someone to modify the below formula to arrive at the second smallest number.<br />
<br />
MIN(IF($EH$14:$EH$105462=E<wbr />H15,$DH$14<wbr />:$DH$10546<wbr />2)))<br />
<br />
Many thanks<br />
<br />
Ian
</div>
</div>


Hi,
I would like someone to modify the below formula to arrive at the second smallest number.

MIN(IF($EH$14:$EH$105462=EH15,$DH$14:$DH$105462)))

Many thanks

Ian

modify formula to find second smallest number

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.