Backwards Searching Using a Formula

macropod · #1 05-17-2011, 01:33 AM

In that case:
=INDEX(B:B,MATCH("*",A1:OFFSET(A1,ROW()-1,0),-1))

OTPM · #2 05-17-2011, 07:58 AM

Hi Paul
Your formula finds the first cell that is non blank as I wanted but how do I return the number immediately to the right of that cell?
Thanks
Tony

OTPM · #3 05-17-2011, 09:17 AM

Quote:

Originally Posted by OTPM

Hi Paul
Your formula finds the first cell that is non blank as I wanted but how do I return the number immediately to the right of that cell?
Thanks
Tony

Hi Paul
My mistake. It works perfectly.
Many thanks for your help.
Tony

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
effective searching	mar999	Office	1	05-04-2011 04:51 AM
Searching dates to create lists	brianh	Excel	2	01-18-2010 01:58 PM
Searching Outlook folders not working	cltaylor	Outlook	0	08-31-2009 10:28 AM
Searching another persons contacts	Hendo313	Outlook	1	07-10-2009 09:03 AM
Visio 2002 backwards compatible with 2000	franklyorange	Visio	0	11-17-2008 11:00 AM