Forum Discussion
Trying to sort/filter data (two criteria), but not sure how to best go about it.
I have data organized across multiple columns, with thousands of field rows per column. I am only interested in key data in several columns. For simplicity sake, I'll call the data in row A, Prim...
If you have the most recent version of Excel, a combination of the UNIQUE and FILTER functions should be able to do it. Is it possible for you to post a representative sample of the kind of data you're working with. Create a set of fictitious data rows if the real stuff is confidential or private.
Without that most recent version of Excel, there are Sort and Filter capabilities on the Data tool bar. The UNIQUE and FILTER functions are more dynamic and powerful.