Posted to microsoft.public.excel.programming

external usenet poster

Posts: 208

DEFINED NAMES AND FORMULAS

I have an area of time formats that I have defined a name to, I use this for
cell validation, so they can only pick from the time I give. Can a formula
read off of the defined name, such as SUMPRODUCT((A1:A100=DEFINED
NAME)*D1:D100)

Thanks,

Sean

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
Defined Names in Formulas when copying Worksheets in a Workbook	Todd_Loves_Spreadsheets	Excel Discussion (Misc queries)	1	October 22nd 09 05:05 AM
Defined Range Names in formulas	Darby	Excel Discussion (Misc queries)	2	October 13th 09 04:41 PM
Defined names	DREED	Excel Discussion (Misc queries)	3	March 10th 06 02:55 PM
Defined Names	rickv	Excel Programming	4	August 6th 05 01:39 PM
hiding formulas and defined names in a worksheet	alldreams	Excel Programming	7	April 9th 04 06:20 PM

All times are GMT +1. The time now is 11:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us