Objective is to retrieve records
which does not have appraisals(mid year appraisal & Year end appraisal) for more than 1 year.
If any one appraisal has been done, then no need to retrieve that record.
I have used Advanced filter with COUNTBLANK function to perform this .In this i got stuck up.
I am attaching a sample data.
Countblank
-
-
-
Hope you are looking for something like the attached workbook.
-
Thanks a lot for the info.
If possible, please explain abt the criteria range which you have applied in (L4:M6 ) in the file you have sent. -
In Range (L:M) checking your criteria, ie, Is there any appraisal for that year. If there is no appraisal, it will bring true, else it will bring false. Then the advance filter looking for where blank is true and it brings the result. Hope u understand the logic behind it.
Mac
-
Thanks for the information.
1. Whether I should frame the criteria for each year (now for 2 years it has done)
2. How can i view the records for which appraisal (mid year & year end) that hasnot been done for 3 years or above. -
-
Here is a sample workbook for three years. For every year you have to add one more column and put the formula as show in the workbook.
Best RegardsMac
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!