Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Or function or macro to compare 3 columns of numbers
Good morning;
I am not sure if I should post here or Excel programming. I need a function or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D..., This would be across rows. If any of the values matched, I.E. A1, B1, C1, matched D1, then enter the value in in E1, Else enter "No Match" in E1. This would need to compare the columns row by row for approximately 3,000 rows of data. Is it possible to use an If Or function for more than two comparisons without going to a macro. Thanks in advance Phil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Or function or macro to compare 3 columns of numbers
Enter this on the first row then copy down
=IF(OR(A1=D1,B1=D1,C1=D1),D1,"No Match") "AuthorizedUserPF" wrote: Good morning; I am not sure if I should post here or Excel programming. I need a function or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D..., This would be across rows. If any of the values matched, I.E. A1, B1, C1, matched D1, then enter the value in in E1, Else enter "No Match" in E1. This would need to compare the columns row by row for approximately 3,000 rows of data. Is it possible to use an If Or function for more than two comparisons without going to a macro. Thanks in advance Phil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Or function or macro to compare 3 columns of numbers
One way:
Entered in E1 and copied down as needed: =IF(COUNTIF(A1:C1,D1),D1,"no match") -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good morning; I am not sure if I should post here or Excel programming. I need a function or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D..., This would be across rows. If any of the values matched, I.E. A1, B1, C1, matched D1, then enter the value in in E1, Else enter "No Match" in E1. This would need to compare the columns row by row for approximately 3,000 rows of data. Is it possible to use an If Or function for more than two comparisons without going to a macro. Thanks in advance Phil |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Or function or macro to compare 3 columns of numbers
Thanks
akphidelt That will work. "AuthorizedUserPF" wrote: Good morning; I am not sure if I should post here or Excel programming. I need a function or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D..., This would be across rows. If any of the values matched, I.E. A1, B1, C1, matched D1, then enter the value in in E1, Else enter "No Match" in E1. This would need to compare the columns row by row for approximately 3,000 rows of data. Is it possible to use an If Or function for more than two comparisons without going to a macro. Thanks in advance Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to compare numbers in 3 columns 3/23/08 | Excel Discussion (Misc queries) | |||
Formula to compare numbers in 3 columns | Excel Discussion (Misc queries) | |||
How do I compare tow columns of numbers? | Excel Discussion (Misc queries) | |||
Compare text/numbers in different columns. | Excel Discussion (Misc queries) | |||
How do I compare two Excel columns of numbers and see non-matches | Excel Worksheet Functions |