Results 1 to 3 of 3

Using drop down menus to analyse data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-22-2006
    MS-Off Ver
    2010
    Posts
    201

    Using drop down menus to analyse data

    Hi, i have attached a simple spreadsheet containing my data.
    The first row contains the headings.
    What I would like to do is create a menu page that would allow you to analyse the data by any of the fields, and look up certain values in any field and return the data set.

    For example, all rows relating to group 1 in "Method" (H column), or
    All entries where start date between 20 Feb 2009 and 24 Feb 2009 (col I).
    or
    All of Manager B (column K) data where the category is "Finished" (column N)

    At the moment there are 64 test rows of data, that will grow, and could be as much as 10,000 rows.

    Is this possible, and any help gratefully received.

    Thanks as always.
    Attached Files Attached Files

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