| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - need a function to compare lists
http://www.cpearson.com/excel/duplic...tingDuplicates
-- Kind regards, Niek Otten "JerryMatson" wrote in message ... At work I am constantly using VLOOKUP to compare one long list to other lists to determine common elements or differences between the lists. I need a simple function that will let me input two lists (named ranges?) and an argument to output items in the first list that are common to the second list, or items that are not common. In other words, I think, the ability to AND the lists or OR the lists, to use Boolean terms. The final argument would probably have to be an output range. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Should Have a History Function. | Excel Worksheet Functions | |||
| linear interpolation function in excel | Excel Worksheet Functions | |||
| @ and "function not valid" error (Excel 2003) | New Users to Excel | |||
| Changing case on mailing lists I receive in Excel 2003? | Excel Worksheet Functions | |||
Hybrid Mode
