If you take my suggested approach, you can have the same formula in C2 (copied down) and this one in B2:
=IF(OR(C2=MAX(C:C),C2=""),"",INDEX(A:A,MATCH(C2+1,C:C,0))&"-"&A2)
which just reverses the order.
Hope this helps.
Pete
If you take my suggested approach, you can have the same formula in C2 (copied down) and this one in B2:
=IF(OR(C2=MAX(C:C),C2=""),"",INDEX(A:A,MATCH(C2+1,C:C,0))&"-"&A2)
which just reverses the order.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks