How to hide rows w/in a set time frame?
Closed
2stxbix
-
May 11, 2010 at 01:14 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 04:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 04:24 PM
column A has a list of driver license numbers. If one of these driver license numbers repeats i would like it to highlight with in an 18 month time span. If the date of the offense which in located in column G is longer than 18 months form the current date i would like the entire row to be hidden and part of the duplication process.
I am currently working on a government program that allows people to take a class across the state where they can only take the class once in an 18 month period. I want the spreadsheet to be able to pick up duplicates using the driver license number in column A only if it falls with 18 months of the current date
I am currently working on a government program that allows people to take a class across the state where they can only take the class once in an 18 month period. I want the spreadsheet to be able to pick up duplicates using the driver license number in column A only if it falls with 18 months of the current date
Related:
- How to hide rows w/in a set time frame?
- How to hide app store on ipad - Guide
- Popcorn time download - Download - Movies, series and TV
- How to set whatsapp time - Guide
- Photo frame editor - Download - Image editing
- How to set redial in android - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 11, 2010 at 06:41 PM
May 11, 2010 at 06:41 PM
Why not just apply filter ?
Rizvisa1 i appreacite your concern.
I would like thi spreadsheet to be active in that as i enter that data it only highlights things with in a certain time period. Your right in that i can filter a certain time period but but if you filter based on tiem period and put a duplication format on it the conditional formatting will shows the dupliation even with the filter in place. I would like the highlighted cell to unhighlight if it is outside the 18 month range
I would like thi spreadsheet to be active in that as i enter that data it only highlights things with in a certain time period. Your right in that i can filter a certain time period but but if you filter based on tiem period and put a duplication format on it the conditional formatting will shows the dupliation even with the filter in place. I would like the highlighted cell to unhighlight if it is outside the 18 month range
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 12, 2010 at 04:24 PM
May 12, 2010 at 04:24 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ etc and post back here the link to allow better understanding of how it is now and how you foresee.