Home |
Search |
Today's Posts |
#21
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 -- skarbanan ------------------------------------------------------------------------ skarbanan's Profile: http://www.excelforum.com/member.php...o&userid=29901 View this thread: http://www.excelforum.com/showthread...hreadid=496084 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent help needed - floating segmented bar chart | Charts and Charting in Excel | |||
Urgent Help needed - I need to stop a process that is running forever in Excel | Excel Discussion (Misc queries) | |||
Urgent Help Needed with coloumn compare | Excel Discussion (Misc queries) | |||
Help, Excel Formula Needed -- Urgent | Excel Worksheet Functions | |||
Urgent help needed: IF function | Excel Worksheet Functions |