if statement of 3 numbers choose last number

[zzz444]

hi guys ,we need aa formula which tracks the input results of (1,2,3) and in case which there are 10 inputs with not repeating numbers choose the last number.thanks a lot!

[Kaper]

And what if there are 10 inputs with repeating numbers?

For now you may test the forllowing array formula:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

[zzz444]

great!!!how can it change to 11 repeatitions?

[Kaper]

Please Login or Register  to view this content.

Just a reminder - Array formula!

[zzz444]

thanks so much!

[Kaper]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

And thanks for reputation!