Hi All

I have a list of data in excel that is made up of alpha-numeric text
(job numbers), that has a second column to the right that has dollar
values. The list has blank lines within it. Similar to this

Column A Column B
abcd1234 123.50
wxyz8596 100.00

thed5555 150.00
huji7777 0.00

I have been able to use the array formula:
=IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<"",ROW(BlanksRange),ROW()+ROWS(Bl anksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))

to filter Column A to get rid of the blank rows. While I don't actually
follow how this formula works (I copied it from someone elses post) I
have successfully managed to filter column A and get rid of the blank
rows.

Now comes the but........

What I would really like to do is apply this to both columns. By this I
mean that I want to filter the data based on Column A and get rid of any
blank rows, but at the same time I want to keep the link to the dollar
value so that my resulting data would look like this

Column A Column B
abcd1234 123.50
wxyz8596 100.00
thed5555 150.00
huji7777 0.00

In addition to this I want to be able to discard the job numbers that
have a zero dollar value (this can be done in two steps if need be), so
that the ultimate result would look like this:

Column A Column B
abcd1234 123.50
wxyz8596 100.00
thed5555 150.00

I know - I don't want much !

Any suggestions / help would be appreciated

Many thanks in advance

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=394152