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

Similar discussions

How to compare two different columns
ABACUS -
TrowaD -

1 response
WinMerge - How to compare the content of two PDF documents?
Isasis -
ac3mark -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
compare and count
vinod -
pcsces -

1 response