I actually solved it anopther way staying with my current setup and
formulas , basically for anyone that has this issue , what i did was,
on the column of names that shows up :
a
1 NONE
2 NONE
3 NONE
4 BILL
5 NONE
6 NONE

I made a if string that said if the first is NONE go to the next column
if its not none display the cell, it was a really long string but hey it
works. Was sorta like this.

=if (a1=none,if(a2=none,if(a3=none,NONE,a3),a2),a1)

It works great..


--
me+excel=crazy
------------------------------------------------------------------------
me+excel=crazy's Profile: http://www.excelforum.com/member.php...o&userid=28868
View this thread: http://www.excelforum.com/showthread...hreadid=486165