Posted to microsoft.public.excel.misc

Killer

external usenet poster

Posts: 80

Excel Formula Question!

This formula works fine but it enters results before all data has been entered.

=INDEX(B10:B49,IF(COUNT(AP10:AP49)=COUNTIF(AP10:AP 49,"<0"),MATCH(MAX(AP10:AP49),AP10:AP49,0),MATCH(M IN(IF(AP10:AP49=0,AP10:AP49)),AP10:AP49,0)))

My question is can this be prevented until the all data has been entered?

Thanks ahead!

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
Formula Question for Excel	Formula applied to whole spreadsheet?	Excel Discussion (Misc queries)	2	September 19th 07 03:42 PM
Excel formula question.	Jaycee	Excel Worksheet Functions	10	November 17th 06 04:52 PM
Excel Formula Question	Mark	Excel Worksheet Functions	2	October 13th 06 05:12 PM
excel formula question	Mona	Excel Worksheet Functions	3	August 22nd 06 05:49 AM
An Excel Formula Question	JWCardington	Excel Worksheet Functions	6	September 24th 05 09:00 PM

All times are GMT +1. The time now is 03:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us