Help to adapt Formula syntax to work with Dynamic Named Ranges

Sam via OfficeKB.com

Posts: n/a

Hi Domenic,

That's Perfect:-

=Stock!$R$71:INDEX(Stock!$R$71:$R$65536,MATCH(9.99 999999999999E+307,Stock
!$R$71:$R$65536))

Thank you very much for all your time and patience. Most appreciated.

Thanks
Sam

--
Message posted via http://www.officekb.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Trouble with Syntax - IF formula	Bert via OfficeKB.com	New Users to Excel	1	April 8th 05 01:00 AM
Formula syntax error - chinese and gibberish	Joshua Fandango	Excel Discussion (Misc queries)	3	March 29th 05 01:27 PM
Need help to set-up a formula on Excel work sheet?	wiskeyjoexxx	New Users to Excel	1	January 15th 05 02:59 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula?	Arvi Laanemets	Excel Discussion (Misc queries)	0	December 2nd 04 11:29 AM
Syntax For Conditional Formula	Dmorri254	Excel Worksheet Functions	9	November 6th 04 03:42 AM

All times are GMT +1. The time now is 02:30 AM.

Menu

About Us