Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minif
=MIN(IF(P3:Q30,P3:R3)
I am using CTRL,SHFT and ENTER to enter this formula as an array but it won't except it MS Office 97 " If I copy an old formula as above from worksheet setup in 98 as soon as I enter array it does not accept it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MINIF ???? | Excel Worksheet Functions | |||
Minif / Maxif ? | Excel Worksheet Functions | |||
MINIF /MAXIF Or something similar | Excel Discussion (Misc queries) |