| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Helpful New Functions: ALL and ANY
I'd really like Excel to have an All(range, criteria) function, as used in a
number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
Think ..
=ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE would be the same as using: =COUNTIF(A1:C1,"y")=COLUMNS(A1:C1) =COUNTIF(A1:D1,"y")=COLUMNS(A1:D1) and .. =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE would be the same as using: =COUNTIF(A1:C1,"y")0 =COUNTIF(A1:C1,"n")0 =COUNTIF(A1:C1,"o")0 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
See your previous post.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Atreides" <atreides1AThotmailD0Tcom wrote in message ... I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
On Mon, 25 Sep 2006 01:49:02 -0700, Atreides <atreides1AThotmailD0Tcom wrote:
I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? You could always use the array entered formulas: =AND(rng="y") for ALL and =OR(rng="y") for ANY --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
Cute!
"Ron Rosenfeld" wrote in message ... On Mon, 25 Sep 2006 01:49:02 -0700, Atreides <atreides1AThotmailD0Tcom wrote: I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? You could always use the array entered formulas: =AND(rng="y") for ALL and =OR(rng="y") for ANY --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
Thanks.
On Mon, 25 Sep 2006 14:17:07 +0100, "Bob Phillips" wrote: Cute! "Ron Rosenfeld" wrote in message .. . On Mon, 25 Sep 2006 01:49:02 -0700, Atreides <atreides1AThotmailD0Tcom wrote: I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: A B C D 1 y y y n 2 3 =ALL(A1:C1, "y") -- TRUE =ALL(A1:D1, "y") -- FALSE In a similar vein, the ANY function would be quite handy: =ANY(A1:C1, "y") -- TRUE =ANY(A1:C1, "n") -- TRUE =ANY(A1:C1, "o") -- FALSE Anyone else think so? You could always use the array entered formulas: =AND(rng="y") for ALL and =OR(rng="y") for ANY --ron --ron |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helpful New Functions: ALL and ANY
"Atreides" <atreides1AThotmailD0Tcom wrote in message
... I'd really like Excel to have an All(range, criteria) function, as used in a number of programming languages. For instance: Just out of curiosity, can you tell me a programming language other than SQL that has an ALL or ANY function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
