Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have 5 columns of data, the first column is time. In this column each row
is incremented in 5mins. So it goes 0,5,10,15,20,25 etc. I want to filter the data to only show rows every 60 minutes i.e. 0,60,120,180 etc. Have can i do this, ive had a play with filters but cant seem to find a way. I have 1000's of minutes so it is a pain to manually select each row. many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
In Excel: select the last 20 rows of data in a column | Excel Worksheet Functions | |||
SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
Select all data, multiple rows | Excel Discussion (Misc queries) |