Results 1 to 3 of 3

Thread: COUNTIF, May be?

  1. #1

    COUNTIF, May be?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    A solution using COUNTIFS. Let me know if this works for you.
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    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.

  3. #3

    Solved

    Ken, worked like charm. Thank you so much for the formula.
    Last edited by Helal; 2011-12-06 at 10:36 PM. Reason: SOLVED

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •