The data is taken from the first encountered cell within the range that
does not equal 'none'

More to the point is that, based on the original data, and then on the
second shown data, 'Bill' will appear as a player for the first team.

The first data showed a blank row between teams, in which case the
formula will show the desired results.
The second data shows no detectable break between teams and the formula
does not test for same-team-person.


The OP's explanation is a little vague when said that "-made a if
string that said if the first is NONE go to the next column-" but
appears to mean the next row.

Those points could just be in the presented test data, and although not
a method that would be recommended the item may work for the OP's
requirement.


damorrison Wrote:
what happens if more than cell doesn't equal "none"


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486165