array formula u excel-u

pozdrav.

jedno pitanje imam,

da li postoji neka array foruma u excelu.

ako imam npr kolonu A u kojoj su brojevi u koloni B je formula: A2/MAX($A$1:A2)-1,
i u C1=min(B:B)

da li je moguce nekako napisati u jednoj celiji. dakle MIN(i ovo sto stoji u koloni B)

sad kad napisah ovo sto hocu, sve mi se cini da je nemoguce.

MAX($A$1:A2) bi moglo da se piše kao MAX(OFFSET(rng; ; ; ROW(INDIRECT("1:" &ROWS(rng));1)), ovako naslepo.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

a rng bi bilo definisano za ukpan broj?

A što ne bi moglo (matrična formula):
=MIN((A2:A22)/MAX((A2:A22):A2)-1)

ne dobijem isti rezultat. tako sam i pokusala.


tj. negde daje tacan rezultat, negde ne. u vecini slucajeva ne. hmmmm??!!

<sub>[Ovu poruku je menjao ramzesIV dana 19.03.2012. u 16:47 GMT+1]

[Edit: Tagovi]

[Ovu poruku je menjao 3okc dana 22.03.2012. u 09:32 GMT+1]</sub>

jel ne postoji neki drugi nacin? da odustanem od ovoga?

@Brodoplovac

Ne može da radi MIN na celom opsegu jer je reč o *parcijalnom* MIN, tj na delovima opsega. Moglo bi, kada bi se na tome ostalo ali ovde se taj parc.min. obrađuje i rezultat mora biti različit!

@ramzesIV

Možda da postaviš fajl sa podacima? Naravno, ne kompletnu dokumentaciju, samo *izolovani deo* o kome je reč.
Svi koji su volji da pomognu su ti unapred zahvalni. :p

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

evo primera:

Za neki opseg 'ops' (kod tebe u A1:A1535) imaš matričnu formulu

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

ops - to znaci definisem ime opsega kao ops= A1:A349?

jer meni stalno javlja da je pogresno napisana formula.

Opseg 'OPS' sam stavio umesto reference sa kojim računaš u toj pom.kol. jer je alijas čitkiji.
Mora da radi, bilo da imenuješ, bilo da zameniš sa aktuelnim opsegom.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!