I have several columns of hundreds of records.
I want to pick out those text records common to three or more columns- according to my choice, preferably without transferring them to a new worksheet, but will if essential- and show them in a new column.
This works in Excel 2000 for two columns only using the advanced filter function.
Any ideas / solutions? Thanks
