vesnabukleskamk
New Member
- Joined
- Oct 2, 2019
- Messages
- 2
Hi, honestly i have no idea wich formula to use in excel2010 - to solve this problem.
I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column.
However the second exmle the value in deposit 1 is one and i need to check if it appears in deposit 2 column. from the example it is the third value - so i can conclude that deposit 1 can be found in deposit 2 column. If i can perform this chech my result is valid and should get OK comment. (table A)
Table B - shows example where the value in deposit 1 can not be found in column deposit 2 - this data set is not valid and should get NOTOK comment.
The original data set is a lot of rows - i have created fields Accout, deposit 1 and deposit 2 with pivot . then i copy the reslult in excel and add the check coulumn with deposit1=deposit2. This is a very long proces to see if the value (always one) can be found in column 2 - and is done manualy
What can i use in excel , pivot or additional formula to solve this problem in shorter time and more advaced way ???
A)
<tbody>
</tbody>
b)
<tbody>
</tbody>
I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column.
However the second exmle the value in deposit 1 is one and i need to check if it appears in deposit 2 column. from the example it is the third value - so i can conclude that deposit 1 can be found in deposit 2 column. If i can perform this chech my result is valid and should get OK comment. (table A)
Table B - shows example where the value in deposit 1 can not be found in column deposit 2 - this data set is not valid and should get NOTOK comment.
The original data set is a lot of rows - i have created fields Accout, deposit 1 and deposit 2 with pivot . then i copy the reslult in excel and add the check coulumn with deposit1=deposit2. This is a very long proces to see if the value (always one) can be found in column 2 - and is done manualy
What can i use in excel , pivot or additional formula to solve this problem in shorter time and more advaced way ???
A)
Account | depozit1 | depozit2 | check depozit1=depozit2 |
41002003111 | 210501683413000 | 210501683413000 | TRUE |
Account | depozit | deposit2 | proverka 1 |
41003053222 | 42104000888 | 42104000666 | FALSE |
42102001555 | FALSE | ||
42104000888 | TRUE |
<tbody>
</tbody>
b)
Account | depozit | deposit_account | proverka 1 |
41003053555 | 42104000123 | 42104000999 | FALSE |
42102001888 | FALSE |
<tbody>
</tbody>