Posted to microsoft.public.excel.worksheet.functions

Mac-OTR

external usenet poster

Posts: 4

Finding a value in a Table

Thanks,

I'll try that one too.

"Herbert Seidenberg" wrote:

This array formula finds the row of the
last occurrence of Target in MyArray
=MAX((MyArray=Target)*ROW(MyArray))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding a vlookup table	Purple Phil	Excel Worksheet Functions	2	October 20th 06 07:35 PM
Finding pieces of a value in a table	root	Excel Discussion (Misc queries)	6	July 21st 06 06:31 PM
Finding pieces of a value in a table	root	Excel Discussion (Misc queries)	0	July 21st 06 03:55 PM
Finding pieces of a value in a table	root	Excel Discussion (Misc queries)	0	July 21st 06 03:55 PM
finding value from table	andyell	Excel Worksheet Functions	4	June 10th 06 12:25 AM

All times are GMT +1. The time now is 05:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us