+ Reply to Thread
Results 1 to 5 of 5

Eliminate the first blank cell from a list.

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Eliminate the first blank cell from a list.

    In the example I have a list of names and payments made. I have tried to generate a unique list of unpaid names but I am getting blank in the first cell in the list (cell P3 in the file). So far I have been unable to resolve this issue.

    Jim O
    Attached Files Attached Files
    Last edited by JO505; 12-04-2014 at 03:16 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Eliminate the first blank cell from a list.

    Here's another way to extract the list of people with balances using an array formula. Cells with formulas are highlighted in green. Does this work?
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Eliminate the first blank cell from a list.

    Thanks very much for the response. I think that will do just fine.

    Thanks again.

    Jim O

  4. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Eliminate the first blank cell from a list.

    Non-array solution

    =IF(ROWS(A$1:A1)>COUNTA($F$3:$F$37)-COUNTIF($F$3:$F$37,"paid"),"",INDEX($C$3:$C$37,SMALL(INDEX(($F$3:$F$37<>"paid")*(ROW($F$3:$F$37)-ROW($F$3)+1),),COUNTIF($F$3:$F$37,"paid")+ROWS(A$1:A1))))

    Copy down as far as needed
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Eliminate the first blank cell from a list.

    Thanks ACE,

    Good to know a non-array method.

    Jim O

+ 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: 7
    Last Post: 02-01-2014, 01:48 AM
  2. [SOLVED] Using Array in VBA to eliminate blank columns in a row
    By NitroN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 08:37 AM
  3. VBA Macro to eliminate cells with a blank value
    By paulxl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2012, 10:23 AM
  4. Eliminate Blank Cells
    By ruby1766 in forum Excel General
    Replies: 20
    Last Post: 06-18-2009, 05:24 PM
  5. Eliminate creating list that returns blank cells
    By Marc Todd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 06:06 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