LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skarbanan
 
Posts: n/a
Default Urgent help needed!


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent help needed - floating segmented bar chart Jeff B Charts and Charting in Excel 1 October 14th 05 07:21 AM
Urgent Help needed - I need to stop a process that is running forever in Excel shadestreet Excel Discussion (Misc queries) 2 October 6th 05 09:59 PM
Urgent Help Needed with coloumn compare Brento Excel Discussion (Misc queries) 1 July 29th 05 12:35 AM
Help, Excel Formula Needed -- Urgent Urgent Excel Worksheet Functions 2 December 14th 04 10:32 PM
Urgent help needed: IF function Terence Excel Worksheet Functions 3 November 16th 04 02:29 AM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"