Have you looked into Auto-Filter? If not, Highlight your entire range
of data (include column headers) that you want to work with (say this
range is A1:B100, where A1 and B1 contain the headers "Job" and "Cost")
then click ToolsFilterAuto Filter...

Note that the cells A1 and B1 now have down arrows in them. Click on
the A1 arrow and notice that all values contained within your range in
that column are listed. Scroll to the bottom and select "Non-Blanks".
All rows that are blank in Column A will be hidden. Now repeat this for
Column B, all rows that are blank in B will be hidden.

What is left is the data you want.

Is this what you are looking for?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=394152