Sorting and re-sorting columns in Excel/Numbers

I would think that there are multiple ways to do that.

1. You could filter the third column on the "0"s and then highlight all of those rows and delete them, then remove the filter and only the non-0s would remain

2. You could simply sort by the third column ascending or whatever and again select the rows with 0s and delete them leaving non-0s

3. I find it odd that you just have 2 columns of numbers that happen to pair up perfectly, you may be simplifying the scenerio for assistance. If this is the case, then you may want to use the vlookup formula to match up column 1 and column 2 first based on certain criteria that you need, and then simply delete out the unmatched blanks using a filter. Keep in mind that Alt ; is a very powerful key combination to select only viewable data to copy and paste into a new tab in the spreadsheet if needed.

4. I believe that there is a match formula in excel, although I have never used it personally

That's the thing about excel, the more you use it the more tricks you learn! And there are almost always multiple ways to do accomplish the same task. I use it everyday, and when excel 2007 went to 1 million rows I was sooooo happy compared to excel 2003 65,536 rows or so. In working with cell numbers and such we often have over 1 million row database results (easy), but sometimes i luck out and it falls under the million and I can excel it instead of using access which is never fun (i HATE access most of the time as it is limited to like 2gb of data as well I believe, which is a lot in all honesty, but sometimes not enough and we need to make more than 1 LOL).

Anyway, good luck, hope that some of this helped out .

Peace...