This should be simple
 

I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=557389

This should be simple
 

You have a response in .excel

Spreadsheet wrote:

I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?

--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=557389

--

Dave Peterson

This should be simple
 

Try:

=IF(COUNT(A1,A3,A5,A7,A9,A11)=1,MAX(A1,A3,A5,A7,A9 ,A11),"")
--
Gary's Student


"Spreadsheet" wrote:


I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=557389

This should be simple
 

Thanks, that works.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=557389