Remove Data which is not match with other column

[Dingdang]

Hi,

I am downloading data from 2 different system in to xls and need t
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. manually step to remove data which is ver
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 formul
A3-D3 and B3-E3 and copying to till end and whenevere there is diffenc
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 colum
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

 

[Don Guillett]

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. manually 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.

This can be done with a macro since formulas can only return values. However, in your sample NOTHING is left ...???