Skip listing record based on value

[LJREdinburgh]

Hi All, I'm sure this has been discussed before but I'm not looking for the correct keyword. Apologies.

I would like Excel to list values only if certain criteria are met. I'm looking for a formula, no VBA please.

An example:

	A	B	C	D
1	Name	Number	Publish?	Up/Down
2	Tom	5	Y	Up
3	David	8	N	Up
4	Steven	4	Y	Up
5	Sean	3	Y	Down
6	Teresa	9	Y	Up
7	Claire	5	N	Down

<tbody>
</tbody>

I want this list to display only records where it says "Up" in column D and where it says "Y" in column C, ie:

	A	B	C	D
1	Name	Number	Publish?	Up/Down
2	Tom	5	Y	Up
3	Steven	4	Y	Up
4	Teresa	9	Y	Up
5

<tbody>
</tbody>

I assume something that incl. =INDEX but I'm not certain.

Thank you for your help.

 

[Gerald Higgins]

Your basic Data, Filter, function can do this.

So can pivot tables.

 

[LJREdinburgh]

Yes, I know but I’m looking for a formula if possible.