A very quick question. I have a client master list with client numbers (which is incomplete) and a database with a list of client transactions. I need to count the number of active clients that I have on board. Active clients is defined as all clients on the client master list + any clients in the transaction database that has sales in the year 2014, but are not in the master client list. I have attached some dummy data. (formula in a simple text box will be ok)
