Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
[excel2003] Compare two rows
Hello,
I would like to compare two rows if the value of row 1 is in row 2. I have used several functions but without succes. Hope someone here can help me to fix this problem. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
[excel2003] Compare two rows
Maybe this will help:
If you want to find a match in row for number in row 2, then in row 3 type the formula =MATCH(A1,2:2,0) and copy it along for as many cells as you want.. It tells you where the match is, if one exists, or shows #N/A if no match exists The 0 at the end is: match_type is 0, MATCH finds the first value that is exactly equal to lookup_value. Lookup_array can be in any order. Regards Philip "RedCell" wrote in message ... Hello, I would like to compare two rows if the value of row 1 is in row 2. I have used several functions but without succes. Hope someone here can help me to fix this problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Compare columns | Excel Discussion (Misc queries) |