Just a place to track tricks and tips I’ve used.<\/p>\n
Just used 2 handy ones(Excel 2003):<\/p>\n
To identify a unique list of values from a column Choose Data->Filter->Advanced Filter
\nIn the list range, choose the cells to check.
\nClick the “unique records only” box.
\nIf you want to copy the unique list somewhere, choose “copy to another location” and select that location.<\/p>\n
To look for intersection between two columns:
\n=IF(ISNA(MATCH(D2,E:E,0)),””,”X”)
\nD2 is the first cell to check. E:E means we are looking for dups in column E.
\nan X will show up if D2 is found in column E.
\nCopy the formula down as far as you want to check column D.<\/p>\n","protected":false},"excerpt":{"rendered":"
Just a place to track tricks and tips I’ve used. Just used 2 handy ones(Excel 2003): To identify a unique list of values from a column Choose Data->Filter->Advanced Filter In the list range, choose the cells to check. Click the … Continue reading