Results 1 to 4 of 4

Only Show data that matches criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question Only Show data that matches criteria

    Hello

    I have a spreadsheet where from a list of 4000 customers I need to bring the details of about 150 to another page for further analysis. I have attached a sample sheet to show what I want with the "data" sheet representing the details of the 4000 customers and the "Main" one representing the 150 in which I'm interested. All I want to show in "Main" A2, A3, etc is the account numbers from "Data" A2, A3, A4 etc if "data" B2, B3, B4 etc says "TRUE" next to the relevant cell - in my example returning the data I've shown in cells "Main" F2, F3 and F4.

    The data in the "data" sheet is coming straight from live SQL database and it would be great if the rows on the "Main" sheet could automatically update if relevant rows are added to the table on the "data" sheet.
    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