LJREdinburgh
New Member
- Joined
- May 20, 2014
- Messages
- 46
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:
<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:
<tbody>
</tbody>
I assume something that incl. =INDEX but I'm not certain.
Thank you for your help.
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.
Last edited: