Tequilashot
New Member
- Joined
- Aug 17, 2015
- Messages
- 33
Sorry I had no idea what title to give this post, so may sound confusing.
<tbody>
</tbody>
What I need is some sort of index match formula to be able to ignore any row with "Paid" in it, I would like something that returns the value of cells A2 and A6 (as they are overdue) and be able to list them in a separate table. I understand a quick filter with a copy and paste can do this but I was wondering is there such a formula that will populate a new table for me automatically?
My results would look something like this;
<tbody>
</tbody>
It's probably something simple but it's the end of the day and my brain is melted, any help would be appreciated.
Supplier1 | 100 | Paid | |
Supplier 2 | 150 | Overdue | |
Supplier 3 | 125 | Paid | |
Supplier 4 | 130 | Paid | |
Supplier 5 | 140 | Paid | |
Supplier 6 | 200 | Overdue | |
Supplier 7 | 200 | Paid | |
Supplier 8 | 150 | Paid |
<tbody>
</tbody>
What I need is some sort of index match formula to be able to ignore any row with "Paid" in it, I would like something that returns the value of cells A2 and A6 (as they are overdue) and be able to list them in a separate table. I understand a quick filter with a copy and paste can do this but I was wondering is there such a formula that will populate a new table for me automatically?
My results would look something like this;
Supplier 2 | 150 | |
Supplier 6 | 200 |
<tbody>
</tbody>
It's probably something simple but it's the end of the day and my brain is melted, any help would be appreciated.