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
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
formula if you have credit in one column, debit in next column
Jack -
Jackthelad -

4 responses