Results 1 to 7 of 7

Search bottom to top of a column to displaying all results that match a criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2022
    Location
    England
    MS-Off Ver
    MS365 (PC) Version 2308
    Posts
    59

    Question Search bottom to top of a column to displaying all results that match a criteria

    Hello all, this problem has been bothering me for days so I’m really hopeful someone here can help. (I’ve attached a sample workbook with additional notes)

    In a nutshell I’m looking to search a list of invoice numbers in Column B for any that have the “ - Finished “ flag on them. However where it gets too hard for me is the fact I’m looking to do this search from the bottom of column B to the top of column B and return all the results that have the “ - Finished “ flag.

    Quick data without the sample workbook.
    982
    145
    353 - Finished 23/08/22
    876
    904
    123 - Finished 01/08/22
    353
    991
    402
    321 - Finished 18/07/22
    678
    609
    297 - Finished 30/07/22
    558

    Result desired (note these are not in date order but merely results taken from the bottom of the column up to the top of the column, when the “ - Finished “ flag is present)
    297 - Finished 30/07/22
    321 - Finished 18/07/22
    123 - Finished 01/08/22
    353 - Finished 23/08/22
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] using ISNUMBER(SEARCH()) with a list and displaying the results.
    By Mat87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2017, 01:09 PM
  2. [SOLVED] Search for Text and displaying the results
    By ymaster44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 12:20 PM
  3. Macro, to match criteria in one column and copies results into a new tab
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2013, 08:57 AM
  4. [SOLVED] Search for Identifier in Column (different sheet) and Displaying Results in Specific Cells
    By Velocir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 11:37 AM
  5. [SOLVED] Finding and Displaying data results from search criteria
    By winlam in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2012, 11:25 PM
  6. displaying search results after searching 2 cbo's
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2010, 08:19 AM
  7. Displaying Search results (filtering?)
    By Klok in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-04-2009, 06:45 AM

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