Hi,
First of all i'm new here. i've been experimenting with Excel for a while now.
So i got this list i just to keep track of what i have to do in a week. i want an overview tab with tasks for sertain days.
i've come to the point i got a pretty good list.
now the problem is. when i put date (in "Status project") in cells C2, C3 and F4 it works fine, returning the data from A2, A3 and D4. When i put date's in C2, F3 and C3 it somewhat swaps the output and i get the data from A2, A3 and D4.
i'v included the document. Fill in what i just said and look for the outcome.
code is use per cell where i need the data (Dutch in the doc, here in English):
=INDEX('Status project'!Afdrukbereik;SMALL(IF('Status project'!Afdrukbereik=A1;ROW('Status project'!1:41)-MIN(ROW('Status project'!1:41))+1;"");1);SMALL(IF('Status project'!Afdrukbereik=A1;COLOMN('Status project'!A:R)-MIN(COLOMN('Status project'!A:R))-1;"");1))
Bookmarks