Don Guillett wrote:
You could use
=IF(COUNT(A1,D1,T1)=0,"",MIN(A1,D1,T1))
Yes, that does the job superbly.
I can add "-" or "x" and that's what it returns. :-)
I can also have as many or as few cells in the combinations. :-)
Change MIN to MAX where required.
This is great.
Many thanks again, much appreciated :-)
--
Keith (Southend)
http://www.southendweather.net
e-mail: kreh at southendweather dot net