LinkBack URL
About LinkBacks
In which case, adaptation of original suggestion
C3:
=IF($A3="","",LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/($A$2:$A2=""),$B$2:$B2)&$A3)))
copied down
In which case, adaptation of original suggestion
C3:
=IF($A3="","",LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/($A$2:$A2=""),$B$2:$B2)&$A3)))
copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks