I am trying to create a task list of pending tests on 1 main worksheet from another worksheet with multiple account numbers for the same person.
I need to match the account number (which is repeated multiple times on the worksheet I am pulling from) to a column that may or may not have a date. If a date is present it means the test is completed and if not the test is pending. When done I only want to show if any tests are "Pending". I don't want to show zero's or any other values. Every formula I try comes up with too many arguments.
Here's what I am working with
<tbody>
</tbody>
I need to match the account number (which is repeated multiple times on the worksheet I am pulling from) to a column that may or may not have a date. If a date is present it means the test is completed and if not the test is pending. When done I only want to show if any tests are "Pending". I don't want to show zero's or any other values. Every formula I try comes up with too many arguments.
Here's what I am working with
Acct # | Test | Acct # | Test Type | Date Completed | |||
1 | 1 | ABC | 1/18/2018 | ||||
2 | 1 | ABC | 6/15/2017 | ||||
3 | 2 | ABC | 9/6/2018 | ||||
4 | 2 | ABC | 8/15/2017 | ||||
5 | 3 | ABC | 3/2/2017 | ||||
6 | 3 | DEF | 3/8/2016 | ||||
7 | 3 | JKL | 05/16/17 | ||||
8 | 4 | ABC | 7/1/2018 | ||||
9 | 4 | ABC | 5/11/2018 | ||||
10 | 4 | GHI | 06/04/18 | ||||
5 | ABC | ||||||
5 | ABC | 8/17/2018 | |||||
6 | ABC | 7/6/2018 | |||||
7 | GHI | 06/30/17 | |||||
9 | ABC | ||||||
9 | ABC | 7/28/2017 | |||||
9 | JKL | 10/06/17 | |||||
9 | JKL | ||||||
10 | ABC | ||||||
10 | ABC | 3/30/2017 | |||||
10 | ABC | 3/30/2017 | |||||
10 | ABC | 9/28/2017 | |||||
10 | JKL | 11/26/17 | |||||
10 | DEF | 10/31/2017 |
<tbody>
</tbody>