View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skarbanan
 
Posts: n/a
Default Urgent help needed!


Thank you biff. You did a great job.I odn't know how to thank you.
I have a last request....could you explain me this forumula ?

{=IF(SUMPRODUCT(--(Dates=$B10);--(nomi=$B$6))=COLUMNS($A:A);INDEX(Magazine;SMALL(I F((Dates=$B10)*(nomi=$B$6);ROW(Magazine)-ROW(C$4)+1);COLUMNS($A:A)));"")}
i mean i understand the functions...but i never used this signs "--"
and "{}" when i click on the fomula the "{}" dissapear end another
value comes out...
This is what i don't understand....

Biff thanks again!


--
skarbanan
------------------------------------------------------------------------
skarbanan's Profile: http://www.excelforum.com/member.php...o&userid=29901
View this thread: http://www.excelforum.com/showthread...hreadid=496084