Array Formula to search two criteria at once

Hi all,

I've created a calendar of events and have managed to use an array formula to pull through events from a list of data (multiple events per day) using the formula below, which is in the blocked out line (and 3 below) on the screenshot:

=INDEX('Data View'!$C:$D,SMALL(IF('Data View'!$C:$C=B$5,ROW('Data View'!$C:$C)),ROW(1:1)),2)

Data View: where my original information about the event is saved
Column C: full date on Data View sheet
Column D: title of the event on Data View sheet
B5: date as shown on the calendar itself (to search from)

Screenshot 2.JPG


I now want to create a second calendar that does this but also will not pull through any events that I've marked as private. They have been marked on the Data View sheet in column N and are either 'Public' or 'Private'.

Does anyone know how I would add this into the formula that's already there? Let me know if you need any more info to be able to help!

Thanks

In the present formula you do not need to use index both c and D columns, so

Formula:

Please Login or Register  to view this content.

will be enough
For the second Calendar you could use:

Formula:

Please Login or Register  to view this content.

PS. It's easier to answer if sample file is attached.

In DAtaView Sheet, row 130 you have the only event for April 20
It is:
2019 April Saturday 20 April 2019 Event 129 Other Saturday 20 April 2019 Daily Location 92 Event 129 Draft Private

So formula in F113 in Event Calendar View (first event on April 20th)

Formula:

Please Login or Register  to view this content.

will show it (as it is Private, but formula

Formula:

Please Login or Register  to view this content.

will return show empty cell (because it's not Public).

Have a look at formulas in rows 113:116 (in saved version checking Public Events) and changes in Event types (N column) for events from this week - I changed some to Public and they are visible in calendar, while private event129 on 20th Apr is not.