need a help for abcd pattern tendency

Reply #4

SirMetro — Fri, 03 Mar 2006 18:36:11 GMT

Perhaps I do not fully understand the question, but in case I do, I use to use the following;

First, I would reduce the 4 digit number set to it's least amount (example 4321 would reduce to 1234) with the following formula.

=CONCATENATE((SMALL(D2:G2,1)),(SMALL(D2:G2,2)),(SMALL(D2:G2,3)),(SMALL(D2:G2,4)))

{the SMALL function will look at a group of numbers and then return the number per the position listed, a four digit number would use 1 thru 4. Because the 4 cells being referenced hold... [ More ]

Reply #3

sysp34 — Sun, 26 Feb 2006 12:15:40 GMT

thanks doug

i just knew the nested limitation

Nested IF Function/Formula Nesting Limit Limitation

One limitation of Excel is that we can only nest formulas up to 7 levels. This is particularly limiting when trying to add nested IF Functions/Formulas that require greater than 7 conditions.

i guess it fix with new MSO 12

and the abcd pattern tendency had solve with simple vlookup, although it take more size.

thanks

ragwi

Reply #2

JADELottery — Sun, 26 Feb 2006 08:34:29 GMT

You could have too many nested functions.

I think the limit is 7.

Reply #1

Raven62 — Sat, 25 Feb 2006 20:37:42 GMT

You need an equal number of close parentheses to your open parentheses

need a help for abcd pattern tendency

sysp34 — Sat, 25 Feb 2006 19:32:50 GMT

dear master spreadsheet at LP member

please guide me to create abcd pattern tendency, i'm trying to create abcd function it work for single function but when i try to merge in one column it won't work.

please help me.

column

e4 for 1st

f4 for 2nd

g4 for 3rd

h4 for 4th

=IF(AND(e4=f4,e4=g4,e4=h4,f4=g4,f4=h4,g4=h4), AAAA ,

IF(AND(e4=f4,e4=g4,e4 h4,f4=g4,f4 h4,g4 h4), AAAB ,

IF(AND(e4=f4,e4 g4,e4=h4,f4 g4,f4=h4,g4 h4), AABA ,

IF(AND(e4=f4,e4 g4,e4 h4,f4 g4,f4 h4,g4=h... [ More ]