Forum Discussion
Match nearest values in two columns
Need to rearrange table based on column name Deducted amt by matching same/nearest values
| Transaction Date | S.No | Amount Paid / Credited | Deducted amt | As per Metro | Deducted amt |
| 01-Apr-2019 | 1 | 48,728.00 | 975.00 | 2 | 17,983.00 |
| 01-Apr-2019 | 2 | 15,388.00 | 308.00 | 1 | 307.76 |
| 01-Apr-2019 | 3 | 8,99,150.00 | 17,983.00 | 6 | 9,586.20 |
| 01-Apr-2019 | 4 | 50,452.00 | 1,009.00 | 3 | 1,170.00 |
| 01-Apr-2019 | 5 | 17,608.00 | 352.00 | 3 | 990.00 |
| 11-Apr-2019 | 6 | 7,63,776.00 | 15,276.00 | 3 | 3,702.34 |
| 11-Apr-2019 | 7 | 4,25,136.00 | 8,503.00 | 3 | 1,23,529.70 |
| 11-Apr-2019 | 8 | 61,76,485.00 | 1,23,530.00 | 3 | 16,718.36 |
| 15-Apr-2019 | 9 | 1,85,117.00 | 3,702.00 | 3 | 15,275.52 |
| 17-Apr-2019 | 10 | 3,45,670.00 | 6,913.00 | 3 | 8,502.72 |
| 17-Apr-2019 | 11 | 20,925.00 | 418.00 | 4 | 418.50 |
| 17-Apr-2019 | 12 | 70,468.00 | 1,409.00 | 4 | 6,913.40 |
| 17-Apr-2019 | 13 | 3,50,586.00 | 7,012.00 | 4 | 1,409.36 |
| 17-Apr-2019 | 14 | 8,35,918.00 | 16,718.00 | 4 | 7,011.72 |
| 18-Apr-2019 | 15 | 58,500.00 | 1,170.00 | 5 | 230.82 |
| 18-Apr-2019 | 16 | 49,500.00 | 990.00 | 5 | 16,592.00 |
| 01-May-2019 | 17 | 4,79,310.00 | 9,586.00 | 5 | 2,149.80 |
| 07-May-2019 | 18 | 9,84,467.00 | 19,689.00 | 5 | 1,709.20 |
| 07-May-2019 | 19 | 1,26,396.00 | 2,528.00 | 5 | 2,527.92 |
| 07-May-2019 | 20 | 2,44,120.00 | 4,882.00 | 5 | 19,689.35 |
| 07-May-2019 | 21 | 56,14,996.00 | 1,12,300.00 | 5 | 4,882.39 |
| 07-May-2019 | 22 | 8,32,320.00 | 16,646.00 | 5 | 1,12,299.92 |
| 07-May-2019 | 23 | 10,60,796.00 | 21,216.00 | 5 | 16,646.40 |
| 20-May-2019 | 24 | 85,460.00 | 1,709.00 | 5 | 21,215.91 |
| 20-May-2019 | 25 | 11,541.00 | 231.00 | 7 | 12,955.73 |
| 20-May-2019 | 26 | 8,29,600.00 | 16,592.00 | 7 | 79,871.64 |
| 20-May-2019 | 27 | 1,07,490.00 | 2,150.00 | 7 | 13,317.12 |
| 23-May-2019 | 28 | 24,44,657.00 | 48,893.00 | 7 | 48,893.14 |
| 23-May-2019 | 29 | 6,65,856.00 | 13,317.00 | 7 | 3,134.58 |
| 23-May-2019 | 30 | 39,93,582.00 | 79,872.00 | 7 | 6,813.62 |
| 23-May-2019 | 31 | 6,47,786.00 | 12,956.00 | 8 | 13,492.62 |
| 23-May-2019 | 32 | 1,56,729.00 | 3,135.00 | 8 | 1,249.54 |
| 23-May-2019 | 33 | 3,40,681.00 | 6,814.00 | 9 | 1,326.40 |
| 23-May-2019 | 34 | 6,74,631.00 | 13,493.00 | 9 | 325.16 |
| 23-May-2019 | 35 | 62,477.00 | 1,250.00 | 9 | 15,223.40 |
| 30-May-2019 | 36 | 5,08,788.00 | 10,176.00 | 9 | 1,829.88 |
| 30-May-2019 | 37 | 63,71,436.00 | 1,27,429.00 | 9 | 2,752.20 |
| 30-May-2019 | 38 | 4,30,848.00 | 8,617.00 | 9 | 848.70 |
| 30-May-2019 | 39 | 14,80,784.00 | 29,616.00 | 9 | 10,895.40 |
| 01-Jun-2019 | 40 | 9,78,790.00 | 19,576.00 | 9 | 1,470.64 |
| 01-Jun-2019 | 41 | 78,700.00 | 1,574.00 | 9 | 6,458.12 |
| 01-Jun-2019 | 42 | 1,97,916.00 | 3,958.00 | 9 | 1,27,428.73 |
| 01-Jun-2019 | 43 | 18,043.00 | 361.00 | 9 | 8,616.96 |
| 04-Jun-2019 | 44 | 5,44,770.00 | 10,895.00 | 9 | 29,615.69 |
| 04-Jun-2019 | 45 | 7,61,170.00 | 15,223.00 | 9 | 10,175.77 |
| 04-Jun-2019 | 46 | 16,258.00 | 325.00 | 10 | 1,44,822.34 |
| 04-Jun-2019 | 47 | 66,320.00 | 1,326.00 | 10 | 9,987.84 |
| 04-Jun-2019 | 48 | 1,37,610.00 | 2,752.00 | 10 | 12,118.84 |
| 04-Jun-2019 | 49 | 42,435.00 | 849.00 | 10 | 5,560.02 |
| 04-Jun-2019 | 50 | 91,494.00 | 1,830.00 | 10 | 740.00 |
| 04-Jun-2019 | 51 | 3,22,906.00 | 6,458.00 | 10 | 700.00 |
| 04-Jun-2019 | 52 | 73,532.00 | 1,471.00 | 10 | 710.00 |
| 12-Jun-2019 | 53 | 6,05,942.00 | 12,119.00 | 11 | 715.58 |
| 12-Jun-2019 | 54 | 72,41,117.00 | 1,44,822.00 | 11 | 17,221.20 |
| 12-Jun-2019 | 55 | 2,78,001.00 | 5,560.00 | 11 | 920.68 |
| 12-Jun-2019 | 56 | 4,99,392.00 | 9,988.00 | 11 | 3,958.32 |
| 20-Jun-2019 | 57 | 37,000.00 | 740.00 | 11 | 360.86 |
| 20-Jun-2019 | 58 | 35,000.00 | 700.00 | 11 | 19,575.80 |
| 01-Jul-2019 | 59 | 4,81,118.00 | 9,622.00 | 11 | 1,574.00 |
| 01-Jul-2019 | 60 | 16,07,361.00 | 32,147.00 | 11 | 9,622.37 |
| 01-Jul-2019 | 61 | 59,495.00 | 1,190.00 | 11 | 1,21,573.35 |
| 01-Jul-2019 | 62 | 60,78,668.00 | 1,21,573.00 | 11 | 12,533.76 |
| 01-Jul-2019 | 63 | 6,26,688.00 | 12,534.00 | 11 | 32,147.22 |
| 02-Jul-2019 | 64 | 46,034.00 | 921.00 | 11 | 1,189.90 |
| 02-Jul-2019 | 65 | 8,61,060.00 | 17,221.00 | 12 | 2,449.97 |
| 02-Jul-2019 | 66 | 35,779.00 | 716.00 | 12 | 1,20,215.48 |
| 13-Jul-2019 | 67 | 17,92,109.00 | 35,842.00 | 12 | 12,533.76 |
| 13-Jul-2019 | 68 | 1,22,498.00 | 2,450.00 | 12 | 35,842.19 |
| 13-Jul-2019 | 69 | 6,26,688.00 | 12,534.00 | 57 | 16,373.80 |
| 13-Jul-2019 | 70 | 60,10,774.00 | 1,20,215.00 | 57 | 1,103.36 |
| 25-Jul-2019 | 71 | 32,516.00 | 650.00 | 14 | 650.32 |
| 25-Jul-2019 | 72 | 67,780.00 | 1,356.00 | 14 | 1,355.60 |
| 25-Jul-2019 | 73 | 3,927.00 | 79.00 | 14 | 4,167.40 |
| 25-Jul-2019 | 74 | 2,08,370.00 | 4,167.00 | 14 | 78.54 |
| 26-Jul-2019 | 75 | 76,166.00 | 1,523.00 | 14 | 213.08 |
| 26-Jul-2019 | 76 | 79,25,944.00 | 1,58,519.00 | 14 | 16,176.40 |
| 26-Jul-2019 | 77 | 5,67,936.00 | 11,359.00 | 14 | 1,523.32 |
| 26-Jul-2019 | 78 | 39,337.00 | 787.00 | 14 | 4,671.00 |
| 26-Jul-2019 | 79 | 2,33,550.00 | 4,671.00 | 14 | 786.75 |
| 26-Jul-2019 | 80 | 10,654.00 | 213.00 | 14 | 1,58,518.88 |
| 26-Jul-2019 | 81 | 8,08,820.00 | 16,176.00 | 14 | 11,358.72 |
| 06-Aug-2019 | 82 | 63,33,256.00 | 1,26,665.00 | 15 | 13,463.04 |
| 06-Aug-2019 | 83 | 5,87,520.00 | 11,750.00 | 15 | 1,26,665.12 |
| 07-Aug-2019 | 84 | 6,73,152.00 | 13,463.00 | 15 | 11,750.40 |
| 08-Aug-2019 | 85 | 63,402.00 | 1,268.00 | 16 | 47.00 |
You've had almost 60 views, no responses. Might I be so bold as to suggest that the reason for the lack of responses is that your post doesn't make total sense. You give an example of a close match from the second row of that lengthy table, but don't give any idea of the significance of that close match other than that it's an example of a close match--which is evident on the surface.
So the question to you is "So What?!"
Those two numbers are only 24 cents apart. Down a bit lower there are two numbers that are 50 cents apart. Again, one wonders "so what?!" What are you wanting to do. You say "rearrange the table" but there are multiple ways to rearrange a table; which rearrangement do you have in mind?
By the way, it's not good practice to have two columns in a table with the same heading.
You're far more likely to get a response if you explain what it is we're looking at, what the different columns and rows represent. Along the way, you might find it clearer to give a slightly different name to one of those two columns that currently are headed "Deducted amt"
And if you can do this, post a copy of the actual spreadsheet on OneDrive or GoogleDrive with a link pasted here that grants access.
