S
skarbanan
Thanks Biff. I read the information about "--" signs and i understand it
know.
I understood your code only not this part :
IF((Dates=$B13)*(nomi=$B$6);ROW(Magazine)-ROW(C$4)+1);2));"")
Well the ROW(Magazine)-ROW(C$4)+1);2) are giving this result 1
Row(Magazine)=4 -ROW(C$4)+1)= c4=4 + 1 = 4
so ROW(Magazine)-ROW(C$4)+1);2)) equals 1, but when i put the number 1
instead of the formula it gives another value...Now i'm asking:is it
because it's an array formula and the searching of the data stops at
every row to continue from the last row or it's somethin else?
Just for curiosty and to understan the formula i triey to put ROW(B2)+1
(which is the same as the next one) instead of ROW(C$4)+1 but it gives
me a wrong result...
could you explain please? I't that i'm really into it and i would like
to learn...
p.s sorry for being boring
know.
I understood your code only not this part :
IF((Dates=$B13)*(nomi=$B$6);ROW(Magazine)-ROW(C$4)+1);2));"")
Well the ROW(Magazine)-ROW(C$4)+1);2) are giving this result 1
Row(Magazine)=4 -ROW(C$4)+1)= c4=4 + 1 = 4
so ROW(Magazine)-ROW(C$4)+1);2)) equals 1, but when i put the number 1
instead of the formula it gives another value...Now i'm asking:is it
because it's an array formula and the searching of the data stops at
every row to continue from the last row or it's somethin else?
Just for curiosty and to understan the formula i triey to put ROW(B2)+1
(which is the same as the next one) instead of ROW(C$4)+1 but it gives
me a wrong result...
could you explain please? I't that i'm really into it and i would like
to learn...
p.s sorry for being boring