The formula as shown doesn't work, the 'none' needs to be in quotes,
however the test and use of A3 remains unneccassary

The formula works equally for

=IF(A1="none",IF(A2="none",A3,A2),A1)




me+excel=crazy Wrote:
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..


--
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