Posted to microsoft.public.excel.misc

Herbert Seidenberg Herbert Seidenberg is offline

external usenet poster

Posts: 1,180

nth value in an array formula

Excel 2007 Pivot Table
Works on text.
One easy non-array formula:
=([Deadline]-[Milestone]<6)*([MyCriteria]=1)
No hidden rows. Dynamic resize.
http://www.mediafire.com/file/lgajntlwldm/03_16_09.xlsx

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
Array Formula Help	klmiura	Excel Worksheet Functions	2	February 11th 09 07:28 PM
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM
An array formula to sum row max	ucamms	Excel Discussion (Misc queries)	2	June 27th 05 08:54 PM

All times are GMT +1. The time now is 01:42 PM.

About Us

"It's about Microsoft Excel"