If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Array help Part 2
thanks for your personal count of key strokes
maybe a diffrence of 21-3CSE = 18 only... I just simply follow help files about array formulation with braces plus your smart build-up of formula of an IF's arrangement. -for classic reading. hope to learn more classic tricks. thanks again and looking forward to see Orchard again... "Max" wrote: "driller" wrote: thanks to all who help You're welcome. i just found out a milder formula like this with a CSE =IF(AND(SUM(--(EXACT($C$1:$E$3,F6))),SUM(--(EXACT($C$1:$E$3,G6))),SUM(--(EXACT($C$1:$E$3,H6)))),IF(ISERROR((F6&G6&H6)+0),F 6&G6&H6,(F6&G6&H6)+0),"") cheers , more power ^2!!! It's a trade-off. Using SUM you do save on the keystrokes: "PRODUCT" x 3 = 21 keystrokes in total here, and that results in a shorter looking formula, but it requires array-entry (CSE) unlike using SUMPRODUCT which doesn't (normal ENTER will do). Just a matter of personal preference, of course g. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#22
|
|||
|
|||
Array help Part 2
maybe a difference of 21-3CSE = 18 only...
It's 19 only then, to be exact, for par comparison SP still requires an ENTER g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Thread Tools | |
Display Modes | |
|
|