Compare columns

Closed

Thanos123 Posts 1 Registration date Sunday September 6, 2009 Status Member Last seen September 6, 2009 - Sep 6, 2009 at 06:18 PM
Jayensmi - Sep 6, 2009 at 10:47 PM

Hello, i'm trying to compare in excel some columns with numbers

Example

i have numbers in columns
A B C D E
i want in column F to give me all numbers that there are in all columns and in column G the numbers that there are in 4 of 5 columns
can anyone help me on this?

Compare columns
Beyond compare download - Download - File management
Excel compare two columns for partial matches - Guide
Excel data validation list from table multiple columns - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum

1 response

Answer 1 / 1

Jayensmi
Sep 6, 2009 at 10:47 PM

Try a vlookup. There is a tutorial at this location http://www.bappit.com/ They have a vlookup tutorial on their site: http://www.bappit.com/uploads/Excel_Vlookup.doc

Similar discussions

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

Extract identical cells of 2 columns (excel)

Macro to compare 2 sheets and copy differences

VBA Compare 2 sheets and output difference to 3rd sheet

Similar discussions

Subscribe To Our Newsletter!