Really need help with excel

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I haven't done any coding in years, and even then i wasn't really that good.

Basically i have two sheets within my spread sheet, named Done and TBD.
In each sheet starting from the cell A2 i have a list going down of customer numbers.

What i am looking for is some sort of code, or guidence so that if any of the customer numbers in the TBD sheet are not on the Done sheet, those customers numbers are copied to a 3rd sheet named "Left" and then at the side of that data (coulmn B) a total number of the customer numbers that were copied to the 3rd sheet is shown.

maybe not possible, but i also have dates etc for events, so the customer numbers can be organised by month, would it be possible to get excel to work out what is left to be done from the 3rd sheet for each month?

thanks for your time, and hope someone gets what i'm going on about.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
use countif to search the no. of occurnces in the second set and then filter out those with values 0

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!