IT Employment

Ask something
Discussion Locked

compare multiple columns in Excel

0 helpful
1 reply

by ezrab_m

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by jdan

off hand I can't think of an easy way to do it in excel without maniuplating the data in a new spreadsheet. if it is a one time thing, I'd do just that and create a pivot table to select the different columns desired.

if it's going to be an ongoing process, you may want to link to the spreadsheet from Access.

name each column in the workbook that you want to compare in excel (highlight the column you want and plug a name in the Name Box - like one, two, three, etc.) then open a new access DB. link tables, select excel file type, select the workbook, click show named ranges, select the first named range (do this for each range). then you can create a query for whatever combination of columns you want.

This discussion is closed to new replies.