| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
compare two columns and display a third
here's the challenge:
-I need to compare 2 columns: A1:A10 and B1:B20 (different range) -For each common value I would like to display the information contained in a third column C1:C20 I did some research on this forum and http://www.cpearson.com/ but so far no good. any help will be greatly appreciate to avoid doing it manually 2000 times. chris90 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 queries: Display last cell, and compare two lists | Excel Worksheet Functions | |||
| Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
| How do I Compare worksheet columns | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| Want labels of columns to display on each page when printing work. | Excel Discussion (Misc queries) | |||
Threaded Mode
