Results 1 to 7 of 7

Finding all the non empty rows in a column depending on user input in custom order.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-06-2020
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    113

    Finding all the non empty rows in a column depending on user input in custom order.

    I have user input in col B2 and output from A14 (containing formula) . I have managed to extract empty rows based on user input (doesnt work if country name repeats and adjacent rows are empty) . I want to sort the data in a order . My expected output is from E14.
    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] Finding all the non empty rows in a column depending on user input.
    By thebeastslayer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2020, 11:48 AM
  2. [SOLVED] Delete specific number of rows for each column with user input
    By Sriramroxx in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-22-2019, 11:28 AM
  3. [SOLVED] need a smarter formula depending on user input
    By lexusap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2017, 12:16 AM
  4. Adding rows depending on user input
    By haitham1984 in forum Excel General
    Replies: 0
    Last Post: 11-10-2008, 07:30 AM
  5. Adding Rows depending on user input
    By haitham1984 in forum Excel General
    Replies: 0
    Last Post: 11-09-2008, 02:35 AM
  6. Adding rows and embedded formulas depending on user input
    By haitham1984 in forum Excel General
    Replies: 5
    Last Post: 11-06-2008, 11:04 AM
  7. Copy rows when column matches a user input from another workbook
    By cjc155 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2008, 04:33 AM

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