Excel - how to hide certain unwanted times?
Closed
rul_C
-
Aug 23, 2009 at 02:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 25, 2009 at 09:50 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 25, 2009 at 09:50 PM
Related:
- Excel - how to hide certain unwanted times?
- How to hide app store on ipad - Guide
- How to see hide story on instagram - Guide
- Number to words in excel - Guide
- How to hide downloaded videos on youtube - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 25, 2009 at 09:50 PM
Aug 25, 2009 at 09:50 PM
use advance filer
your data is from A1 to H16 with row 1 containing column headings date, time, data
now in G1 to H3 type this
time time
>=6:00 am <=8:00 am
>=6:00 pm <=8:00 pm
(remember G1 will have "time" and also H1 will have "time"
1. now click data(menu)-filter-advancefilter
2. in the top under "action"
3. . choose "FILTER THE LIST IN THE PLACE"
4. against list range type
$A$1:$C$16
(or you can click the icon at the right end and move the mouse from A1 to the end of the data" automatically the above will be entered)
5. against "criteria range" type
$G$1:$H$3
(or you can try the same trick as above)
6. click ok.
see what happens
to remove ADVANCEFILTER
click data-filter -showall
the data is restored ( this is in version ecel 2002)
any doubt post back
your data is from A1 to H16 with row 1 containing column headings date, time, data
now in G1 to H3 type this
time time
>=6:00 am <=8:00 am
>=6:00 pm <=8:00 pm
(remember G1 will have "time" and also H1 will have "time"
1. now click data(menu)-filter-advancefilter
2. in the top under "action"
3. . choose "FILTER THE LIST IN THE PLACE"
4. against list range type
$A$1:$C$16
(or you can click the icon at the right end and move the mouse from A1 to the end of the data" automatically the above will be entered)
5. against "criteria range" type
$G$1:$H$3
(or you can try the same trick as above)
6. click ok.
see what happens
to remove ADVANCEFILTER
click data-filter -showall
the data is restored ( this is in version ecel 2002)
any doubt post back
