Results 1 to 3 of 3

Thread: Sorting and filtering Microsoft Excel

  1. #1
    Join Date
    May 2008
    Posts
    193

    Sorting and filtering Microsoft Excel

    Hello,

    I will try to be clear:
    I want in a list of 170 names with different columns (name-nationality-age children-food vouchers) to show the children into two columns, those of maternal age and those of primary school age, to a distribution of toys .
    I wanted to avoid a date to include child per cell, to avoid a proliferation of columns: children who have 6 children, should be 6 columns.

    Is it possible to sort on a cell that would include a group of dates eg for children age maternal type, a single cell in the dates of birth of children in a family: 01 03 05 08. then apply a filter together with 01 to 08.
    How?
    Thank you

  2. #2
    Join Date
    May 2008
    Posts
    335

    Re: Sorting and filtering excel

    hello

    why don't you use a custom AutoFilter ?

  3. #3
    Join Date
    May 2008
    Posts
    347

    Re: Sorting and filtering excel

    Thank you for your réponse.I want to use the AutoFilter custom, but the filters that are listed here are not appropriate. I do not have the opportunity to add. The filter, which should in my case, would be "contains so many to so many 'or more accurately" contains .... to ...". So I would just type: from 00 to 08 to filter kindergarten and type 95 to 99 for those in primary education. And this filter would change the numbers each year.

Similar Threads

  1. Sorting by Surname in Excel
    By Ojsuta in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 04:56 PM
  2. How to avoid cell reference changes after sorting in Excel
    By Wisaal in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:23 PM
  3. How to group multiple lines for sorting in excel
    By Rao's in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 09:34 PM
  4. how to enable Autofilter and Sorting in Protected Excel Sheet
    By ChittiBabu in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:38 PM
  5. Array sorting in Excel
    By Kelsey in forum Software Development
    Replies: 3
    Last Post: 08-11-2008, 04:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,848,726.83746 seconds with 16 queries