JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Need a Excel formula to find out Knock off values based oncriteria and it isdocument date/text should be same, one +ve no. knock with only one -ve no.
Document Date Amount in local currency Remarks 30-09-2022 1,62,00,000.00 28-09-2022 -1,00,00,000.00 28-09-2022 -91,60,835.00 28-09-2022 -87,14,108.00 28-09-2022 -73,44,769.00 31-10-2022 9,89,477.00 11-03-2022 7,14,839.00 09-03-2023 4,41,274.00 30-04-2022 1,45,778.80 31-10-2022 1,14,518.00 31-10-2022 77,580.00 30-04-2022 71,280.00 24-06-2022 58,500.32 Knock off 30-06-2022 58,500.32 24-06-2022 -58,500.32 Knock off 29-05-2022 45,864.00 30-06-2022 38,456.00 24-06-2022 36,549.56 30-06-2022 36,549.56 24-06-2022 -36,549.56 29-05-2022 28,216.00 31-10-2022 27,157.00 31-10-2022 24,150.00 30-06-2022 23,012.00 31-10-2022 18,748.00 09-03-2023 15,312.00 24-01-2023 12,968.00 29-07-2022 12,352.00 31-10-2022 8,920.00 30-03-2023 8,278.00 30-08-2022 7,994.00 30-01-2023 7,930.00 29-07-2022 7,448.00 24-01-2023 6,070.00 30-01-2023 5,990.00 31-10-2022 5,963.00 30-04-2022 5,284.00 09-03-2023 5,100.00 24-01-2023 4,034.00 24-01-2023 3,838.00 30-04-2022 3,680.00 30-08-2022 3,680.00 30-01-2023 3,680.00 31-10-2022 3,615.00 31-10-2022 3,598.00 31-10-2022 3,350.00 30-04-2022 3,240.00 30-03-2023 2,932.00 24-06-2022 2,898.00 30-06-2022 2,898.00 24-06-2022 -2,898.00 29-05-2022 2,880.00 30-01-2023 2,750.00 29-07-2022 2,566.00 24-01-2023 2,296.00 24-06-2022 2,257.00 30-06-2022 2,257.00 24-06-2022 -2,257.00 30-01-2023 2,250.00 28-04-2022 1,850.00 30-04-2022 -1,850.00 30-01-2023 1,850.00 31-01-2023 -1,850.00 30-01-2023 1,760.00 31-01-2023 -1,760.00 30-01-2023 1,736.00 30-01-2023 1,486.00 30-09-2022 1,434.00 31-10-2022 1,420.00 30-01-2023 1,350.00 31-01-2023 -1,350.00 27-02-2023 1,350.00 28-02-2023 -1,350.00 30-03-2023 1,350.00 31-03-2023 -1,350.00 31-10-2022 1,310.00 28-07-2022 1,300.00 31-07-2022 -1,300.00 29-11-2022 1,300.00 30-11-2022 -1,300.00 29-12-2022 1,300.00 31-12-2022 -1,300.00 09-03-2023 1,260.00 29-06-2022 1,250.00 30-06-2022 -1,250.00 01-07-2022 1,250.00 01-07-2022 -1,250.00 31-10-2022 1,231.00 31-10-2022 -1,150.00 29-08-2022 1,100.00 31-08-2022 -1,100.00 30-01-2023 1,090.00 31-01-2023 -1,090.00 30-01-2023 1,040.00 31-01-2023 -1,040.00 30-03-2023 1,032.00 30-01-2023 1,006.00 30-08-2022 1,000.00 24-01-2023 990.00 30-08-2022 958.00 31-05-2022 -950.00 31-05-2022 950.00 29-06-2022 933.00 30-01-2023 920.00 24-01-2023 906.00 30-09-2022 -900.00 29-09-2022 900.00 30-10-2022 900.00 31-10-2022 890.00 31-10-2022 890.00 30-01-2023 886.00 31-01-2023 -886.00 31-01-2023 -860.00 30-09-2022 -850.00 30-01-2023 800.00 31-01-2023 -800.00 30-01-2023 776.00 30-01-2023 760.00 31-01-2023 -760.00 29-07-2022 658.00 28-04-2022 600.00 28-07-2022 600.00 29-08-2022 600.00 31-05-2022 600.00 29-09-2022 600.00 31-10-2022 -600.00 29-11-2022 600.00 29-12-2022 600.00 30-10-2022 600.00 29-12-2022 550.00 31-12-2022 -550.00 27-02-2023 550.00 28-02-2023 -550.00 30-03-2023 550.00 31-03-2023 -550.00 30-01-2023 520.00 30-01-2023 520.00 31-01-2023 -520.00 31-01-2023 -520.00 29-06-2022 510.00 29-09-2022 500.00 29-11-2022 500.00 30-11-2022 -500.00 30-10-2022 500.00 27-02-2023 500.00 30-03-2023 500.00 30-01-2023 494.00 29-06-2022 446.00 29-05-2022 422.00 30-01-2023 402.00 29-08-2022 400.00 31-08-2022 -400.00 30-01-2023 400.00 31-01-2023 -400.00 09-03-2023 398.00 30-01-2023 372.00 30-01-2023 370.00 30-01-2023 362.00 09-03-2023 360.00 29-08-2022 350.00 29-09-2022 350.00 30-10-2022 350.00 30-09-2022 342.00 30-01-2023 335.00 29-06-2022 331.00 29-05-2022 326.00 30-04-2022 326.00 29-08-2022 250.00 29-09-2022 250.00 30-10-2022 250.00 30-01-2023 250.00 31-01-2023 -250.00 30-01-2023 240.00 30-01-2023 240.00 31-01-2023 -240.00 31-01-2023 -240.00 30-01-2023 206.00 29-06-2022 201.00 28-04-2022 200.00 28-07-2022 200.00 31-05-2022 200.00 29-09-2022 200.00 30-01-2023 200.00 30-01-2023 200.00 30-01-2023 200.00 31-01-2023 -200.00 27-02-2023 200.00 30-03-2023 200.00 30-01-2023 196.00 31-01-2023 -196.00 30-01-2023 192.00 30-01-2023 190.00 31-01-2023 -190.00 30-01-2023 180.00 29-06-2022 172.00 30-01-2023 152.00 28-04-2022 150.00 28-04-2022 150.00 28-07-2022 150.00 28-07-2022 150.00 30-09-2022 150.00 31-05-2022 150.00 31-05-2022 150.00 29-11-2022 150.00 29-11-2022 150.00 29-12-2022 150.00 29-12-2022 150.00 30-10-2022 150.00 30-04-2022 146.00 27-02-2023 136.00 29-06-2022 122.00 29-06-2022 122.00 30-01-2023 120.00 30-01-2023 120.00 30-01-2023 120.00 31-01-2023 -120.00 31-01-2023 -120.00 30-01-2023 117.00 30-01-2023 112.00 28-04-2022 100.00 28-04-2022 100.00 28-07-2022 100.00 28-07-2022 100.00 29-08-2022 100.00 31-05-2022 100.00 31-05-2022 100.00 31-05-2022 100.00 29-09-2022 100.00 29-11-2022 100.00 29-11-2022 100.00 29-12-2022 100.00 29-12-2022 100.00 30-10-2022 100.00 27-02-2023 100.00 27-02-2023 100.00 30-03-2023 100.00 30-03-2023 100.00 30-03-2023 100.00 30-01-2023 95.00 09-03-2023 90.00 30-03-2023 -90.00 29-06-2022 87.00 30-01-2023 86.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 31-01-2023 -80.00 31-01-2023 -80.00 30-01-2023 76.00 31-01-2023 -76.00 30-09-2022 -75.00 30-08-2022 75.00 29-06-2022 72.00 29-06-2022 72.00 29-06-2022 72.00 30-01-2023 55.00 31-01-2023 -55.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 30-04-2022 -50.00 30-04-2022 -50.00 31-05-2022 -50.00 31-05-2022 -50.00 29-06-2022 50.00 29-06-2022 50.00 29-06-2022 50.00 30-06-2022 -50.00 30-06-2022 -50.00 01-07-2022 50.00 01-07-2022 50.00 01-07-2022 -50.00 01-07-2022 -50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 31-07-2022 -50.00 31-07-2022 -50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 31-08-2022 -50.00 31-08-2022 -50.00 30-09-2022 -50.00 30-09-2022 -50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 31-10-2022 -50.00 31-10-2022 -50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 30-11-2022 -50.00 30-11-2022 -50.00 30-11-2022 50.00 30-11-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 31-12-2022 -50.00 31-12-2022 -50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-11-2022 -50.00 30-11-2022 -50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 28-02-2023 -50.00 28-02-2023 -50.00 28-02-2023 -50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 31-03-2023 -50.00 31-03-2023 -50.00 31-03-2023 -50.00 30-01-2023 45.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 -40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 40.00 27-02-2023 40.00 28-02-2023 -40.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 30-06-2022 -36.00 30-06-2022 -36.00 01-07-2022 36.00 01-07-2022 36.00 01-07-2022 -36.00 01-07-2022 -36.00 30-01-2023 36.00 30-01-2023 -20.00 29-06-2022 15.00 30-09-2022 14.00 31-10-2022 5.00 31-10-2022 5.00
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Document Date Amount in local currency Remarks 30-09-2022 1,62,00,000.00 28-09-2022 -1,00,00,000.00 28-09-2022 -91,60,835.00 28-09-2022 -87,14,108.00 28-09-2022 -73,44,769.00 31-10-2022 9,89,477.00 11-03-2022 7,14,839.00 09-03-2023 4,41,274.00 30-04-2022 1,45,778.80 31-10-2022 1,14,518.00 31-10-2022 77,580.00 30-04-2022 71,280.00 24-06-2022 58,500.32 Knock off 30-06-2022 58,500.32 24-06-2022 -58,500.32 Knock off 29-05-2022 45,864.00 30-06-2022 38,456.00 24-06-2022 36,549.56 30-06-2022 36,549.56 24-06-2022 -36,549.56 29-05-2022 28,216.00 31-10-2022 27,157.00 31-10-2022 24,150.00 30-06-2022 23,012.00 31-10-2022 18,748.00 09-03-2023 15,312.00 24-01-2023 12,968.00 29-07-2022 12,352.00 31-10-2022 8,920.00 30-03-2023 8,278.00 30-08-2022 7,994.00 30-01-2023 7,930.00 29-07-2022 7,448.00 24-01-2023 6,070.00 30-01-2023 5,990.00 31-10-2022 5,963.00 30-04-2022 5,284.00 09-03-2023 5,100.00 24-01-2023 4,034.00 24-01-2023 3,838.00 30-04-2022 3,680.00 30-08-2022 3,680.00 30-01-2023 3,680.00 31-10-2022 3,615.00 31-10-2022 3,598.00 31-10-2022 3,350.00 30-04-2022 3,240.00 30-03-2023 2,932.00 24-06-2022 2,898.00 30-06-2022 2,898.00 24-06-2022 -2,898.00 29-05-2022 2,880.00 30-01-2023 2,750.00 29-07-2022 2,566.00 24-01-2023 2,296.00 24-06-2022 2,257.00 30-06-2022 2,257.00 24-06-2022 -2,257.00 30-01-2023 2,250.00 28-04-2022 1,850.00 30-04-2022 -1,850.00 30-01-2023 1,850.00 31-01-2023 -1,850.00 30-01-2023 1,760.00 31-01-2023 -1,760.00 30-01-2023 1,736.00 30-01-2023 1,486.00 30-09-2022 1,434.00 31-10-2022 1,420.00 30-01-2023 1,350.00 31-01-2023 -1,350.00 27-02-2023 1,350.00 28-02-2023 -1,350.00 30-03-2023 1,350.00 31-03-2023 -1,350.00 31-10-2022 1,310.00 28-07-2022 1,300.00 31-07-2022 -1,300.00 29-11-2022 1,300.00 30-11-2022 -1,300.00 29-12-2022 1,300.00 31-12-2022 -1,300.00 09-03-2023 1,260.00 29-06-2022 1,250.00 30-06-2022 -1,250.00 01-07-2022 1,250.00 01-07-2022 -1,250.00 31-10-2022 1,231.00 31-10-2022 -1,150.00 29-08-2022 1,100.00 31-08-2022 -1,100.00 30-01-2023 1,090.00 31-01-2023 -1,090.00 30-01-2023 1,040.00 31-01-2023 -1,040.00 30-03-2023 1,032.00 30-01-2023 1,006.00 30-08-2022 1,000.00 24-01-2023 990.00 30-08-2022 958.00 31-05-2022 -950.00 31-05-2022 950.00 29-06-2022 933.00 30-01-2023 920.00 24-01-2023 906.00 30-09-2022 -900.00 29-09-2022 900.00 30-10-2022 900.00 31-10-2022 890.00 31-10-2022 890.00 30-01-2023 886.00 31-01-2023 -886.00 31-01-2023 -860.00 30-09-2022 -850.00 30-01-2023 800.00 31-01-2023 -800.00 30-01-2023 776.00 30-01-2023 760.00 31-01-2023 -760.00 29-07-2022 658.00 28-04-2022 600.00 28-07-2022 600.00 29-08-2022 600.00 31-05-2022 600.00 29-09-2022 600.00 31-10-2022 -600.00 29-11-2022 600.00 29-12-2022 600.00 30-10-2022 600.00 29-12-2022 550.00 31-12-2022 -550.00 27-02-2023 550.00 28-02-2023 -550.00 30-03-2023 550.00 31-03-2023 -550.00 30-01-2023 520.00 30-01-2023 520.00 31-01-2023 -520.00 31-01-2023 -520.00 29-06-2022 510.00 29-09-2022 500.00 29-11-2022 500.00 30-11-2022 -500.00 30-10-2022 500.00 27-02-2023 500.00 30-03-2023 500.00 30-01-2023 494.00 29-06-2022 446.00 29-05-2022 422.00 30-01-2023 402.00 29-08-2022 400.00 31-08-2022 -400.00 30-01-2023 400.00 31-01-2023 -400.00 09-03-2023 398.00 30-01-2023 372.00 30-01-2023 370.00 30-01-2023 362.00 09-03-2023 360.00 29-08-2022 350.00 29-09-2022 350.00 30-10-2022 350.00 30-09-2022 342.00 30-01-2023 335.00 29-06-2022 331.00 29-05-2022 326.00 30-04-2022 326.00 29-08-2022 250.00 29-09-2022 250.00 30-10-2022 250.00 30-01-2023 250.00 31-01-2023 -250.00 30-01-2023 240.00 30-01-2023 240.00 31-01-2023 -240.00 31-01-2023 -240.00 30-01-2023 206.00 29-06-2022 201.00 28-04-2022 200.00 28-07-2022 200.00 31-05-2022 200.00 29-09-2022 200.00 30-01-2023 200.00 30-01-2023 200.00 30-01-2023 200.00 31-01-2023 -200.00 27-02-2023 200.00 30-03-2023 200.00 30-01-2023 196.00 31-01-2023 -196.00 30-01-2023 192.00 30-01-2023 190.00 31-01-2023 -190.00 30-01-2023 180.00 29-06-2022 172.00 30-01-2023 152.00 28-04-2022 150.00 28-04-2022 150.00 28-07-2022 150.00 28-07-2022 150.00 30-09-2022 150.00 31-05-2022 150.00 31-05-2022 150.00 29-11-2022 150.00 29-11-2022 150.00 29-12-2022 150.00 29-12-2022 150.00 30-10-2022 150.00 30-04-2022 146.00 27-02-2023 136.00 29-06-2022 122.00 29-06-2022 122.00 30-01-2023 120.00 30-01-2023 120.00 30-01-2023 120.00 31-01-2023 -120.00 31-01-2023 -120.00 30-01-2023 117.00 30-01-2023 112.00 28-04-2022 100.00 28-04-2022 100.00 28-07-2022 100.00 28-07-2022 100.00 29-08-2022 100.00 31-05-2022 100.00 31-05-2022 100.00 31-05-2022 100.00 29-09-2022 100.00 29-11-2022 100.00 29-11-2022 100.00 29-12-2022 100.00 29-12-2022 100.00 30-10-2022 100.00 27-02-2023 100.00 27-02-2023 100.00 30-03-2023 100.00 30-03-2023 100.00 30-03-2023 100.00 30-01-2023 95.00 09-03-2023 90.00 30-03-2023 -90.00 29-06-2022 87.00 30-01-2023 86.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 30-01-2023 80.00 31-01-2023 -80.00 31-01-2023 -80.00 30-01-2023 76.00 31-01-2023 -76.00 30-09-2022 -75.00 30-08-2022 75.00 29-06-2022 72.00 29-06-2022 72.00 29-06-2022 72.00 30-01-2023 55.00 31-01-2023 -55.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 28-04-2022 50.00 30-04-2022 -50.00 30-04-2022 -50.00 31-05-2022 -50.00 31-05-2022 -50.00 29-06-2022 50.00 29-06-2022 50.00 29-06-2022 50.00 30-06-2022 -50.00 30-06-2022 -50.00 01-07-2022 50.00 01-07-2022 50.00 01-07-2022 -50.00 01-07-2022 -50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 28-07-2022 50.00 31-07-2022 -50.00 31-07-2022 -50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 29-08-2022 50.00 31-08-2022 -50.00 31-08-2022 -50.00 30-09-2022 -50.00 30-09-2022 -50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 31-05-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 29-09-2022 50.00 31-10-2022 -50.00 31-10-2022 -50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 29-11-2022 50.00 30-11-2022 -50.00 30-11-2022 -50.00 30-11-2022 50.00 30-11-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 29-12-2022 50.00 31-12-2022 -50.00 31-12-2022 -50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-10-2022 50.00 30-11-2022 -50.00 30-11-2022 -50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 27-02-2023 50.00 28-02-2023 -50.00 28-02-2023 -50.00 28-02-2023 -50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 30-03-2023 50.00 31-03-2023 -50.00 31-03-2023 -50.00 31-03-2023 -50.00 30-01-2023 45.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 -40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 30-01-2023 40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 -40.00 31-01-2023 40.00 27-02-2023 40.00 28-02-2023 -40.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 29-06-2022 36.00 30-06-2022 -36.00 30-06-2022 -36.00 01-07-2022 36.00 01-07-2022 36.00 01-07-2022 -36.00 01-07-2022 -36.00 30-01-2023 36.00 30-01-2023 -20.00 29-06-2022 15.00 30-09-2022 14.00 31-10-2022 5.00 31-10-2022 5.00
Can any one help me on above request
Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444