4 posts • Page 1 of 1
I have a clients database that has more people than my billing database. I'm trying to figure out who isn't paying by revealing the people on the clients database list that aren't in the billing database.I've sorted them alphabetically and tried to use this example: https://discussions.apple.com/thread/23 ... 0&tstart=0 from Badunit but I'm not sure if that is the correct route. any advice on this?
Charlie, Without seeing your data, it's difficult to prescribe an expression, but we can speak generally here. This seems to me a very simple case for using COUNTIF. If I count the number of occurances of each member of the Client Database in the Billing Database, I should get all zeros and ones. The zeros are the people who are missing from the biling database and the ones are the people who exist in both databases. A sort on the count will organize the names for your examination. Jerry
Hi Jerrold - thanks for the info/advice. here is what my current setup looks like: http://chrle.us/9nwD can you give me a formula that I could use like Badunit has here: https://discussions.apple.com/thread/23 ... 0&tstart=0