Excel - MIN problem

[Guest_imported]

I have a cell set up to select the MIN result of three cells and display the heading of the column containing the lowest figure.

=IF(MIN(B1717)=B17,B6, IF(MIN(B1717)=C17,C6,IF(MIN(B1717)=D17,D6)))

My problem is how to display all the results when more than one cell contains the smallest figure.

Please can anyone advise.

With thanks,

Maureen

 

[Dreamboat]

Dunno how, but why not try conditional formatting instead?
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[mala]

Try
=IF(MIN(B1717)=B17,B6,"&quot&IF(MIN(B1717)=C17,C6,"&quot&IF(MIN(B1717)=D17,D6,"&quot
It'll work!!