Loop Checking function?

  • Thread starter Thread starter grin2000
  • Start date Start date
G

grin2000

I have the following table:

A B
1 Adam -50
2 James MET
3 Hank -800
4 Will -300
5 Bill MET
6 Ken -98
7 Frank -80
8 Kerry -220
9 Ken -400
10 Bond MET


There are these 10 guys which either met their payments or still owe
certain amount. The status column B can either have a negative numbe
in it or the word MET. So all guys could either have met the deadlin
to pay or still owe. I wanted to have shown on another page in 2 colum
shown like this:

A B
1 GOOD BAD
2 James Adam
3 Bill Hank
4 Bond WIll
5 Ken
6 Frank
7 Kerry
8 Ken
9
10


I just don't know what macro or something else would work that can loo
at the first table and then list the people in the right columns, Goo
and Bad on the first page.

Thanks, I appreciate the help
 
Put this in A2, press ctrl/shift/enter, and fill down:

=INDEX(Sheet1!$A$1:$A$10,SMALL(IF(ISTEXT(Sheet1!
$B$1:$B$10),ROW(Sheet1!$B$1:$B$10)),ROW()-1))

and put this in B2 and repeat:

=INDEX(Sheet1!$A$1:$A$10,SMALL(IF(ISNUMBER(Sheet1!
$B$1:$B$10),ROW(Sheet1!$B$1:$B$10)),ROW()-1))

HTH
Jason
Atlanta, GA
 
Back
Top