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
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel macros for finding out recurring values in a column
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