Really need help with excel

Closed
OggDude - Sep 3, 2009 at 03:06 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 3, 2009 at 03:11 AM
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

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