Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a sheet with a number of columns. One of them lists different dates in a format of ''Planned dd/mm/yyyy''. The dates range from 2003 until 2011. I only need those from 2010 and 2011. What I want to do is to find the values with 2010 and 2011 in that column and copy paste them along with the respective rows to another sheet. I would highly appreciate any help.

share|improve this question
    
Are you able to sort the sheet by this column? Although, since it looks like a text field (combined text and date) this might not work to sort in order of date? – w3dk Oct 21 '11 at 8:36
    
I can remove the 'planned' using the find/replace function and change the entire column into a date format. If you have a solution for how to take it from there... – Robert Oct 21 '11 at 8:41

Once you have removed "Planned " from the data and changed the column into date format (as per your comment) then you can select all the rows in the sheet and choose Data > Sort from the menu to sort the sheet by the date column (make sure "No Header Row" is selected). It should then be easy enough to select all rows in 2010/2011, since they are now contiguous, and copy them to another sheet.

share|improve this answer
    
thank you. problem solved. – Robert Oct 21 '11 at 10:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .