Previous Topic Next Topic

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?

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
0

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses