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
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
Last edited by JO505; 12-04-2014 at 03:16 PM.
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?
Thanks very much for the response. I think that will do just fine.
Thanks again.
Jim O
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 *
Thanks ACE,
Good to know a non-array method.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks