| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
data look up and return values across a row
I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
to cross reference with another larger spreadsheet, which we'll call 'spreadsheet B'. I'd like to remove everything from B that isn't on A. Is there an easy way of doing that? |
|
#2
|
|||
|
|||
|
Chip Pearson has lots of info about working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm Betsey wrote: I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need to cross reference with another larger spreadsheet, which we'll call 'spreadsheet B'. I'd like to remove everything from B that isn't on A. Is there an easy way of doing that? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Return Consecutive Values | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Linear Mode
