Thread
: [Solved]
Backwards Searching Using a Formula
View Single Post
05-17-2011, 01:33 AM
macropod
Windows 7 32bit
Office 2007
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
In that case:
=INDEX(B:B,MATCH("*",A1:OFFSET(A1,ROW()-1,0),-1))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
macropod
View Public Profile
Find all posts by macropod