|
|
#1
05-16-2011, 06:37 AM
|
|||
|
|||
Backwards Searching Using a Formula
Hi
I am seaerching for a formula that will reverse search a single column array for the first non blank cell and return the number in the cell to the right of that value. For example: A10 contains "Object Number:", B10 contains "2456" Current Active Cell is A20 Search from A20 backwards to A10 and then when it finds the cell is non-blank then return the value in B10. Any help would be appreciated. Tony 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode