| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing data, need help.
Hello,
I am new to Excel VBA and needs some help with this comparing data between columns. Column A and Column B are comparing with each others. Column A has 10 rows and column B has 5. If it matches, then output "TRUE" otherwise "False" on Column C, outputs are on the same row as the letter it matches of Column B. In this case Column C, row 3 and row 5. It is much easier if it compare straight across using IF Else but this not the case. Thank you very much for the help. Allan For example. Column A: Column B: Column C: Row 1 A U FALSE Row 2 B X FALSE Row 3 C G TRUE Row 4 D Y FALSE Row 5 E H TRUE Row 6 F Row 7 G Row 8 H Row 9 I Row 10 J |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing data, need help.
As you didn't post any code, will you settle for a worksheet formula?... Enter in C1 and fill down... =COUNTIF(A:A,B1)0 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Hello, I am new to Excel VBA and needs some help with this comparing data between columns. Column A and Column B are comparing with each others. Column A has 10 rows and column B has 5. If it matches, then output "TRUE" otherwise "False" on Column C, outputs are on the same row as the letter it matches of Column B. In this case Column C, row 3 and row 5. It is much easier if it compare straight across using IF Else but this not the case. Thank you very much for the help. Allan For example. Column A: Column B: Column C: Row 1 A U FALSE Row 2 B X FALSE Row 3 C G TRUE Row 4 D Y FALSE Row 5 E H TRUE Row 6 F Row 7 G Row 8 H Row 9 I Row 10 J |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing data, need help.
Thank you Jim, yes it works. Another case, if it is true, can I assign a
value to it. For instance. True=A False=B lets make a new row in D1 for the value of true and false. Thanks much. Allan "Jim Cone" wrote: As you didn't post any code, will you settle for a worksheet formula?... Enter in C1 and fill down... =COUNTIF(A:A,B1)0 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Hello, I am new to Excel VBA and needs some help with this comparing data between columns. Column A and Column B are comparing with each others. Column A has 10 rows and column B has 5. If it matches, then output "TRUE" otherwise "False" on Column C, outputs are on the same row as the letter it matches of Column B. In this case Column C, row 3 and row 5. It is much easier if it compare straight across using IF Else but this not the case. Thank you very much for the help. Allan For example. Column A: Column B: Column C: Row 1 A U FALSE Row 2 B X FALSE Row 3 C G TRUE Row 4 D Y FALSE Row 5 E H TRUE Row 6 F Row 7 G Row 8 H Row 9 I Row 10 J |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing data, need help.
You are welcome. Try this... =IF(COUNTIF(A:A,B1)0,"A","B") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Thank you Jim, yes it works. Another case, if it is true, can I assign a value to it. For instance. True=A False=B lets make a new row in D1 for the value of true and false. Thanks much. Allan "Jim Cone" wrote: As you didn't post any code, will you settle for a worksheet formula?... Enter in C1 and fill down... =COUNTIF(A:A,B1)0 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Hello, I am new to Excel VBA and needs some help with this comparing data between columns. Column A and Column B are comparing with each others. Column A has 10 rows and column B has 5. If it matches, then output "TRUE" otherwise "False" on Column C, outputs are on the same row as the letter it matches of Column B. In this case Column C, row 3 and row 5. It is much easier if it compare straight across using IF Else but this not the case. Thank you very much for the help. Allan For example. Column A: Column B: Column C: Row 1 A U FALSE Row 2 B X FALSE Row 3 C G TRUE Row 4 D Y FALSE Row 5 E H TRUE Row 6 F Row 7 G Row 8 H Row 9 I Row 10 J |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing data, need help.
Very nice. Thank you so much. Definitely make my work easier.
Allan "Jim Cone" wrote: You are welcome. Try this... =IF(COUNTIF(A:A,B1)0,"A","B") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Thank you Jim, yes it works. Another case, if it is true, can I assign a value to it. For instance. True=A False=B lets make a new row in D1 for the value of true and false. Thanks much. Allan "Jim Cone" wrote: As you didn't post any code, will you settle for a worksheet formula?... Enter in C1 and fill down... =COUNTIF(A:A,B1)0 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Allan" wrote in message Hello, I am new to Excel VBA and needs some help with this comparing data between columns. Column A and Column B are comparing with each others. Column A has 10 rows and column B has 5. If it matches, then output "TRUE" otherwise "False" on Column C, outputs are on the same row as the letter it matches of Column B. In this case Column C, row 3 and row 5. It is much easier if it compare straight across using IF Else but this not the case. Thank you very much for the help. Allan For example. Column A: Column B: Column C: Row 1 A U FALSE Row 2 B X FALSE Row 3 C G TRUE Row 4 D Y FALSE Row 5 E H TRUE Row 6 F Row 7 G Row 8 H Row 9 I Row 10 J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing two columns of data and return unique data in another co | Excel Discussion (Misc queries) | |||
| Comparing data between sheets, and copying rows with data | Excel Programming | |||
| help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
| comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
| Comparing data in two columns and highlighting the data | Excel Worksheet Functions | |||
Linear Mode
