Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Backwards Searching Using a Formula Backwards Searching Using a Formula
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-17-2011, 01:33 AM
macropod's Avatar
macropod macropod is offline Backwards Searching Using a Formula Windows 7 32bit Backwards Searching Using a Formula Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In that case:
=INDEX(B:B,MATCH("*",A1:OFFSET(A1,ROW()-1,0),-1))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Backwards Searching Using a Formula effective searching mar999 Office 1 05-04-2011 04:51 AM
Backwards Searching Using a Formula 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
Backwards Searching Using a Formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:49 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft