LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 247
Default I Need get work this formula

Best to you

I have this formulas :
=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D 1;D3;D5)<=1;COUNT(E1;E3;E*
5)<=1;COUNT(F1;F3;F5)<=1)
An perfect equivalent for this formula is the next array formula :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0,ISNUMBER(B1:F5) *{1;0;1;0;1})<=1)
in US formula sintax , and in my sintax :
=AND(MMULT(TRANSPOSE(ROW(B1:F5))^0;ISNUMBER(B1:F5) *{1|0|1|0|1})<=1)
________________________________________
Thanks to mr. Harlan Grove I get this formula , which mr. Harlan Grove
said it
is another perfect equivalet for the formulas above ; the new
equivalent is :

=AND(COUNT(MATCH(ROWS(B1:F5);TRANSPOSE({1;3;5}))= 1))

but this formula didn't work stil for me ; can anybody give me the
changes in this last formula
to get it work ?
Thanks very much for your time and knowledge
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 will not work Indymanny Excel Discussion (Misc queries) 6 May 15th 07 10:50 PM
Why does this Formula work? Kevin Vaughn Excel Worksheet Functions 3 April 7th 06 09:21 PM
FORMULA DOESN'T WORK Loyd Excel Discussion (Misc queries) 4 March 30th 06 06:17 PM
A search for $ in a formula use to work now it does not work JuneJuly Excel Discussion (Misc queries) 2 November 30th 05 10:13 PM
My formula does not work! Julie P. Excel Worksheet Functions 5 June 21st 05 02:27 PM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"