I'm not sure if this is possible , if it's not possible please let me know.
Any help will be appreciated.
I'm trying to extract a list from A if B matches " Yes " without showing the errors , completely ignoring the errors.
What I usually use is Index and match to return criteria , but it shows Errors. Trying to skip the error.
This is my List.
<tbody>
</tbody>
Expected Results
<tbody>
</tbody>
Once again thx MrExcel , you've made me so much better in using Excel.
Any help will be appreciated.
I'm trying to extract a list from A if B matches " Yes " without showing the errors , completely ignoring the errors.
What I usually use is Index and match to return criteria , but it shows Errors. Trying to skip the error.
This is my List.
A | B | |
1 | 1st Jan | Yes |
2 | 1st Jan | No |
3 | 1st Jan | Yes |
4 | 2nd Jan | Yes |
5 | 2nd Jan | Yes |
6 | 3rd Jan | No |
7 | 3rd Jan | No |
8 | 4th Jan | Yes |
<tbody>
</tbody>
Expected Results
A | |
1 | 1st jan |
2 | 1st Jan |
3 | 2nd Jan |
4 | 2nd Jan |
5 | 4th Jan |
<tbody>
</tbody>
Once again thx MrExcel , you've made me so much better in using Excel.