+ Reply to Thread
Results 1 to 6 of 6

Report based on same FICO number, multiple times

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Report based on same FICO number, multiple times

    Hello all -

    I am attempting to create a report that where I choose a FICO number in a dropdown menu and it brings up all scenarios where that FICO number appears.

    For example, if I have the FICO score of 800, and I have 5 scenarios of 800, I want to see the all the data for the 5 scenarios that appear in my spreadsheet.

    I initially thought of VLookup, but it only brings up the first instance. I need all instances.

    Any help would be appreciated.

    Thanks.
    Dave

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Report based on same FICO number, multiple times

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

    Also, are you still operating Excel 2007. If you are using a newer version, please update your profile as this will make a BIG difference in the methods available to you for a solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Re: Report based on same FICO number, multiple times

    Here you go!
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Report based on same FICO number, multiple times

    Since you are using 365, you have the Filter Function available to you.
    In the attached, I have copied your headers to row 12
    In B13, I typed the following =FILTER($B$3:$N$7,F3:F7=800)
    Excel will fill in the table as shown.

    If you are using a combobox for the criterria, then change F3:F7=ComboBox Address.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Re: Report based on same FICO number, multiple times

    That worked!
    Thank you.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Report based on same FICO number, multiple times

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Replies: 3
    Last Post: 09-22-2021, 05:16 PM
  2. [SOLVED] Count the number of times a data appear based on multiple criteria between 2 dates
    By lati2008 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-22-2021, 03:53 PM
  3. Replies: 31
    Last Post: 04-26-2021, 08:28 AM
  4. [SOLVED] Copy multiple columns x number of times based on variable number?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2017, 04:13 PM
  5. FICO Movement Problem - Vlookup, If, ISNA PLEASE HELP!
    By henrock24 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2015, 12:21 PM
  6. Replies: 10
    Last Post: 01-30-2014, 04:42 PM
  7. Replies: 6
    Last Post: 03-02-2010, 04:15 PM

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