Hi
Wanted some help with matching problem, i cant find a way to match some numbers.
example.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
i want those two different tables to be matched in one sheet by date and value, and one sheet jus by value
i want exel to show me only values that are in one colum and arent in other colum, and values that can be in one colum and arent in the other colum.
thanks
Wanted some help with matching problem, i cant find a way to match some numbers.
example.
1/6/2016 | 1,200.00 | 1/6/2016 | 1,200.00 | |
1/9/2016 | 1,365.00 | 1/9/2016 | 637.72 | |
1/9/2016 | 1,157.75 | 1/9/2016 | 757.75 | |
1/9/2016 | 757.75 | 1/9/2016 | 1,157.75 | |
1/9/2016 | 640.00 | 1/9/2016 | 1,365.00 | |
1/9/2016 | 377.75 | 1/9/2016 | 335.04 | |
1/11/2016 | 1,775.00 | 1/11/2016 | 975.00 | |
1/11/2016 | 1,298.25 | 1/12/2016 | 1,298.25 | |
1/11/2016 | 975.00 | 1/12/2016 | 1,775.00 | |
1/12/2016 | 680.50 | 1/13/2016 | 680.50 | |
1/12/2016 | (42.75) | 1/13/2016 | 647.75 | |
1/13/2016 | 1,580.00 | 1/13/2016 | 496.00 | |
1/13/2016 | 1,557.75 | 1/14/2016 | 1,580.00 | |
1/13/2016 | 647.75 | 1/14/2016 | 1,557.75 | |
1/13/2016 | 496.00 | 1/15/2016 | 907.75 | |
1/15/2016 | 1,755.00 | 1/15/2016 | 1,755.00 | |
1/15/2016 | 907.75 | 1/16/2016 | 780.00 | |
1/16/2016 | 780.00 | 1/16/2016 | 400.00 | |
1/16/2016 | 780.00 | 1/16/2016 | 780.00 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
i want those two different tables to be matched in one sheet by date and value, and one sheet jus by value
i want exel to show me only values that are in one colum and arent in other colum, and values that can be in one colum and arent in the other colum.
thanks