+ Reply to Thread
Results 1 to 5 of 5

How to sort only one type of data from a column

  1. #1
    Registered User
    Join Date
    06-24-2016
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    4

    How to sort only one type of data from a column

    Hi,
    I am working on a large database, and for that database we need to sort some of the information out and transfer to another sheet. I want to look at only specific data to perform some analysis. For instance, in a spreadsheet that has both male and female workers, how do I create a separate list of only female workers in a new sheet for the same workbook? The only thing that I could think of is VLOOKUP but I am not sure if that will work. Any help would be appreciated! Thanks in advance for your time!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,418

    Re: How to sort only one type of data from a column

    Please post a sample file (not image) demonstrating what you require.

    To upload a file, click "Go Advanced" then scroll down to "Manage attachments"

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: How to sort only one type of data from a column

    Hi @Ranh
    You want create a new table filtered or filtered and sorted? Why not use filter, sort, copy, paste?
    Assuming you want dynamically filter to a new table in a new sheet, and assuming your first table is Table_A with (Name, Gender, Age) in Sheet1
    You can use the following formula in Sheet2 Table_B with(Row_Id, Name, Gender, Age) to get the rows you want transfer ($G$2 has the Filter for Gender).
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Now, you can use INDEX to fill the rest of Table_B as (to get column Name
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See the sample file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-24-2016
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    4

    Re: How to sort only one type of data from a column

    I am not allowed to share the exact database but is there a way I could send a model of what I am working on?
    Last edited by Ranh; 07-25-2016 at 02:41 PM.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,089

    Re: How to sort only one type of data from a column

    Quote Originally Posted by Ranh View Post
    I am not allowed to share the exact database but is there a way I could send a model of what I am working on?
    Yes, make your model as close to the actual data as you can and be sure to include an example of your expected outcome. To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort a two column list alphabetically by type, then by product
    By fjyoder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2016, 05:16 PM
  2. Replies: 1
    Last Post: 03-04-2015, 02:57 PM
  3. [SOLVED] Need to sort pivot table's column labels by type
    By adelkam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2015, 03:27 AM
  4. Sort entire row data with item type and process.
    By sianjialin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2013, 10:10 PM
  5. Copying rows of data depending on the data type in a column
    By mels in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2012, 02:58 AM
  6. Replies: 1
    Last Post: 03-17-2005, 08:06 PM
  7. create macro to move label type data to column data
    By JonathonWood9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1