Question

  • Creator
    Topic
  • #2224892

    Excel macros for finding out recurring values in a column

    Locked

    by manju.jacob ·

    This is what I need to do:
    for worksheet.column= p13 value=’Blocked’

    On activating worksheet
    1.check the status cloumn in each worksheet in the file.
    2.if status value is blocked, give count
    3.check if value is present in defect column where the value of status is blocked.
    4.then check the count of values in defect cloumn.

    should be same as status column with value as blocked, if not throw error, data missing in defect column.

    5. if yes, then count for each value in defect column
    6. check if value is repeated in that column, if yes return
    value of count and the value itself.

    7.if no check next

All Answers

Viewing 0 reply threads