+ Reply to Thread
Results 1 to 2 of 2

Creating a automated table with an if function

  1. #1
    Registered User
    Join Date
    03-05-2008
    Posts
    1

    Creating a automated table with an if function

    Hi

    This is my first post so I don't know if I have put this in the correct loation. Please let me know if there is a better location.

    Anyway my problem is as follows:-

    I have a excel spreadsheet as follows:-
    Date Address Sku
    04/03/2008 ENFIELD UK103801
    04/03/2008 SOUTHAMPTON UK103801
    03/03/2008 GLOUCESTER UK103800
    04/03/2008 REDHILL UK103667
    04/03/2008 ROCHESTER UK103800
    03/03/2008 BIRMINGHAM UK103667
    03/03/2008 Luton UK103667
    03/03/2008 Manchester UK103667
    29/02/2008 BIRMINGHAM UK103620
    29/02/2008 Bedford UK103620
    29/02/2008 Lincoln UK103620
    04/03/2008 BIRMINGHAM UK103620
    29/02/2008 London UK103620
    04/03/2008 Colchester UK103620

    I am looking for way, formula or table, to create a table in another spreadsheet that will list all the rows that equal a specific cell for example I want the table to show all that equal the 04/03/08.

    04/03/2008 ENFIELD UK103801
    04/03/2008 SOUTHAMPTON UK103801
    04/03/2008 REDHILL UK103667
    04/03/2008 ROCHESTER UK103800
    04/03/2008 BIRMINGHAM UK103620
    04/03/2008 Colchester UK103620

    I know this sound like a simple sort function, but the table I am actually using has a lot more data and I want to be able to select specific columns of information that relates to the selected date.

    Does anyone know of an easy way to create this.

    Thanks

    Matt

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by mmoz
    Hi

    This is my first post so I don't know if I have put this in the correct loation. Please let me know if there is a better location.

    Anyway my problem is as follows:-

    I have a excel spreadsheet as follows:-
    Date Address Sku
    04/03/2008 ENFIELD UK103801
    04/03/2008 SOUTHAMPTON UK103801
    03/03/2008 GLOUCESTER UK103800
    04/03/2008 REDHILL UK103667
    04/03/2008 ROCHESTER UK103800
    03/03/2008 BIRMINGHAM UK103667
    03/03/2008 Luton UK103667
    03/03/2008 Manchester UK103667
    29/02/2008 BIRMINGHAM UK103620
    29/02/2008 Bedford UK103620
    29/02/2008 Lincoln UK103620
    04/03/2008 BIRMINGHAM UK103620
    29/02/2008 London UK103620
    04/03/2008 Colchester UK103620

    I am looking for way, formula or table, to create a table in another spreadsheet that will list all the rows that equal a specific cell for example I want the table to show all that equal the 04/03/08.

    04/03/2008 ENFIELD UK103801
    04/03/2008 SOUTHAMPTON UK103801
    04/03/2008 REDHILL UK103667
    04/03/2008 ROCHESTER UK103800
    04/03/2008 BIRMINGHAM UK103620
    04/03/2008 Colchester UK103620

    I know this sound like a simple sort function, but the table I am actually using has a lot more data and I want to be able to select specific columns of information that relates to the selected date.

    Does anyone know of an easy way to create this.

    Thanks

    Matt

    Hi,

    Yes, you should be using the Data-->Filter Advanced Filter functionality from the XL menu.

    For the Criteria Range you need the word 'Date' (i.e. the Field heading of your date column) in the first cell, say A1, and in A2 enter the date of 04/03/2008. A1:A2 is now your criteria range.

    Your output range is as many of the field headings from your s/s as you want to see, set out in a single row of cells.

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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