# Identifying matching values due to transposed numbers

#### Absa

##### New Member
Good day guys

Is there a way to compare two sets of values and return a match based on the possibility that the value in column A could be the same as the value in column be as a result of a transposed capturing error.

e.g Column A = 3124 Column B = 1324

I am trying to reduce the amount of time required to identify possible reasons as to why a total is out of balance. I have already managed to search for values that sum up to the the "out-of-balance" amount; though if this is not the reason as to why it is out-of-balance; the next option would be to determine if numbers of specific values have been transposed.

Regards

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Bump

Replies
2
Views
665
Replies
2
Views
508
Replies
4
Views
3K
Replies
1
Views
715
Replies
5
Views
339

1,196,021
Messages
6,012,904
Members
441,740
Latest member
Latrs

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back