A solution using COUNTIFS. Let me know if this works for you.
I have huge data set that are being updated every month. The data include members names and ids and dates (enrolled to program). I need to assign New, Active, Inactive status to each member based in some criterion. The purpose, logic and sample data are all included in the attached file.
I very much appreciate any help on this.
Thank you in advance,
Helal
A solution using COUNTIFS. Let me know if this works for you.
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Ken, worked like charm. Thank you so much for the formula.
Last edited by Helal; 2011-12-06 at 10:36 PM. Reason: SOLVED
Bookmarks