I am trying to display certain account numbers based on three different criteria. Below is a small version of what I need to look up against: -
Acc Status Can RD Initiated
1234 Live Yes
5678 Dead Yes 15/10/2013
4567 Dead Yes
9874 Dead No
4521 Live No
1457 Live No
4572 Live Yes 22/10/2013
6937 Live Yes 22/10/2013
8472 Live Yes
2365 Dead No
I need it to show me the accounts (acc) where status="Live", Can RD = "Yes" and initiated = "". I know how to count them up using sumproduct, but I'm stuck when it comes to extracting the data! On this list I'd need a table that would show me acc 1234 & 8472.
Can anyone help?
Adam
Bookmarks