dingdang
New member
- Joined
- Oct 7, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi,
I am downloading data from 2 different system in to xls and need to remove invoice no and amount which is not match with other data.
A and B data from one system and D and E data from another system, currently i am doing foll. [COLOR=#3366CC !important]manually[/COLOR] step to remove data which is very time consuming process for me as data is almost 15000 to 18000.
sort A , B and D,E data in assending order, in C column applying formula A3-D3 and B3-E3 and copying to till end and whenevere there is diffence removing each Invoice no and amount from both data .
inv no amount inv no amt
A B D E
4053 15,000.00 4153 15,000.00
5949 99,200.00 5950 99,200.00
6081 20,928.00 6081 20,900.00
10525 5,165.00 10519 5,165.00
11531 19,600.00 11534 19,600.00
11535 2,000.00 11635 2,000.00
13143 20,000.00 13145 20,000.00
13930 16,000.00 13835 16,000.00
13984 327,762.00 13984 327,000.00
Pls help if there is any other formula / macro to remove A and B column data which is not match with D and E .
there are foll. possibilities to be consider.
A and D data would match but B and E may be mismatch
B and E data would match but A and D may be mismatch
data may be not in either A and B or D and E also.
I am downloading data from 2 different system in to xls and need to remove invoice no and amount which is not match with other data.
A and B data from one system and D and E data from another system, currently i am doing foll. [COLOR=#3366CC !important]manually[/COLOR] step to remove data which is very time consuming process for me as data is almost 15000 to 18000.
sort A , B and D,E data in assending order, in C column applying formula A3-D3 and B3-E3 and copying to till end and whenevere there is diffence removing each Invoice no and amount from both data .
inv no amount inv no amt
A B D E
4053 15,000.00 4153 15,000.00
5949 99,200.00 5950 99,200.00
6081 20,928.00 6081 20,900.00
10525 5,165.00 10519 5,165.00
11531 19,600.00 11534 19,600.00
11535 2,000.00 11635 2,000.00
13143 20,000.00 13145 20,000.00
13930 16,000.00 13835 16,000.00
13984 327,762.00 13984 327,000.00
Pls help if there is any other formula / macro to remove A and B column data which is not match with D and E .
there are foll. possibilities to be consider.
A and D data would match but B and E may be mismatch
B and E data would match but A and D may be mismatch
data may be not in either A and B or D and E also.