I've been tasked with taking a list of tens of thousands of items in an Excel spreadsheet. Through the help of fellow MacRumors posters, I've learned how to use formulas to look at the numbers in two different columns and have a third column write the difference between the numbers.
What I want to do now is eliminate all rows whose two columns have the same number. I would say about half of my thirty thousand rows have the same number in both columns, so I'm wondering if there's a way to sort by the number in the third column (which is just the difference between the first two columns), and then eliminate all the rows that show up together with "0" in the third column. After that, I want to go back to the original sorting.
Thanks for any help!
What I want to do now is eliminate all rows whose two columns have the same number. I would say about half of my thirty thousand rows have the same number in both columns, so I'm wondering if there's a way to sort by the number in the third column (which is just the difference between the first two columns), and then eliminate all the rows that show up together with "0" in the third column. After that, I want to go back to the original sorting.
Thanks for any help!