Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding a number of values that adds up to a specific value
I have a column with almost 700 cells containing different values. The column
total should equal zero. Now I have a value 7633,80 instead of zero. I know that this error comes from say 2 to 20 of the values in my column the others should add upp to zero. How do I find which values that adds up to the "non-zero"-value 7633,80? See my data below. Doc. Date Amount 2007-12-16 -21 869,40 2007-12-16 -36 000,00 2007-12-16 -24 872,72 2007-12-16 -109 948,80 2007-12-16 -166 293,75 2007-12-16 -19 901,70 2007-12-16 -48 370,96 2007-12-16 -27 091,20 2007-12-16 -173 250,00 2007-12-16 -175 284,00 2007-12-16 -51 729,60 2007-12-16 -24 473,60 2007-12-16 -31 564,80 2007-12-16 -93 053,40 2007-12-16 -37 557,52 2007-12-16 -321 954,75 2007-12-16 -135 781,80 2007-12-16 -44 928,00 2007-12-16 -168 504,00 2007-12-16 -456 429,60 2007-12-16 -272 522,88 2007-12-16 -50 868,40 2007-12-16 -15 800,00 2007-12-16 -259 248,64 2007-12-16 -13 480,00 2007-12-16 -14 700,00 2007-12-16 -31 260,00 2007-12-16 -33 182,50 2007-12-16 -24 822,00 2007-12-16 -20 600,00 2007-12-16 -40 840,00 2007-12-16 -76 891,50 2007-12-16 -76 891,50 2007-12-16 -46 635,75 2007-12-16 -10 363,50 2007-12-16 -77 726,25 2007-12-16 -35 882,70 2007-12-16 -30 756,60 2007-12-16 -46 635,75 2007-12-16 -30 300,00 2007-12-16 -36 990,00 2007-12-16 -241 639,20 2007-12-16 -121 913,40 2007-12-16 -80 364,96 2007-12-16 -87 094,80 2007-12-16 -400 626,00 2007-12-16 -891 432,36 2007-12-16 -322 372,80 2007-12-16 -468 921,60 2007-12-16 -183 330,72 2007-12-16 -10 784,16 2007-12-16 -113 968,80 2007-12-16 -301 956,48 2007-12-16 -53 328,00 2007-12-16 -64 462,72 2007-12-16 -279 720,00 2007-12-16 -18 648,00 2007-12-16 -282 024,00 2007-12-16 -56 404,80 2007-12-16 -180 403,20 2007-12-16 -36 990,00 2007-12-16 -177 543,00 2007-12-16 -33 850,00 2007-12-16 -8 369,40 2007-12-16 -45 920,00 2007-12-16 -36 000,00 2007-12-16 -51 817,50 2007-12-16 -56 999,25 2007-12-16 -10 363,50 2007-12-16 -35 882,70 2007-12-16 -35 882,70 2007-12-16 -80 578,40 2007-12-16 -17 244,00 2007-12-16 -16 242,00 2007-12-16 -13 232,00 2007-12-16 -39 275,00 2007-12-16 -31 104,00 2007-12-16 -43 650,00 2007-12-16 -109 728,00 2007-12-16 -114 816,00 2007-12-16 -8 094,00 2007-12-16 -8 100,00 2007-12-16 -7 177,50 2007-12-16 -35 579,52 2007-12-16 -48 130,74 2007-12-16 -28 627,20 2007-12-16 -5 186,16 2007-12-16 -11 866,50 2007-12-16 -9 765,60 2007-12-16 -5 295,96 2007-12-16 -175 284,00 2007-12-16 -193 974,00 2007-12-16 -37 557,52 2007-12-16 -77 594,40 2007-12-16 -198 000,00 2007-12-16 -210 630,00 2007-12-16 -44 928,00 2007-12-16 -93 053,40 2007-12-16 -49 531,50 2007-12-16 -47 347,20 2007-12-16 -24 473,60 2007-12-16 -140 652,60 2007-12-16 -196 049,70 2007-12-16 -196 049,70 2007-12-16 -135 586,44 2007-12-16 -454 403,84 2007-12-16 -342 858,60 2007-12-16 -160 250,40 2007-12-16 -78 037,20 2007-12-16 -137 143,44 2007-12-16 -322 372,80 2007-12-16 -40 000,17 2007-12-16 -11 164,80 2007-12-16 -66 988,80 2007-12-16 -322 372,80 2007-12-16 -160 250,40 2007-12-16 -685 717,20 2007-12-16 -319 060,80 2007-12-16 -1 406 764,80 2007-12-16 -80 125,20 2007-12-16 -161 186,40 2007-12-16 -454 403,84 2007-12-16 -454 403,84 2007-12-16 -26 008,32 2007-12-16 -11 890,25 2007-12-16 -231 472,00 2007-12-16 -205 143,84 2007-12-16 -72 284,00 2007-12-16 -4 289,04 2007-12-16 -10 044,00 2007-12-16 -35 508,60 2007-12-16 -193 335,00 2007-12-16 -193 335,00 2007-12-16 -134 870,00 2007-12-16 -134 870,00 2007-12-16 -27 434,00 2007-12-16 -27 434,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -16 000,00 2007-12-16 -25 560,00 2007-12-16 -8 280,00 2007-12-16 -15 120,00 2007-12-16 -38 794,80 2007-12-16 -43 821,00 2007-12-16 -29 250,00 2007-12-16 -87 880,00 2007-12-16 -206 817,60 2007-12-16 -70 106,40 2007-12-16 -408 784,32 2007-12-16 -617 145,48 2007-12-16 -564 152,40 2007-12-16 -240 375,60 2007-12-16 -185 177,60 2007-12-16 -150 978,24 2007-12-16 -48 320,00 2007-12-16 -454 403,84 2007-12-16 -60 956,70 2007-12-16 -200 966,40 2007-12-16 -156 074,40 2007-12-16 -80 593,20 2007-12-16 -350 532,00 2007-12-16 -41 268,00 2007-12-16 -134 870,00 2007-12-16 -61 593,84 2007-12-16 -70 392,96 2007-12-16 -91 489,86 2007-12-16 -104 559,84 2007-12-16 -19 609,92 2007-12-16 -43 940,00 2007-12-16 -29 250,00 2007-12-16 -72 544,50 2007-12-16 -56 387,10 2007-12-16 -61 513,20 2007-12-16 -5 771,72 2007-12-16 -295 746,00 2007-12-16 -40 329,00 2007-12-16 -94 101,00 2007-12-16 -13 500,00 2007-12-16 -17 325,00 2007-12-16 -28 575,00 2007-12-16 -3 425,76 2007-12-16 -5 779,20 2007-12-16 -9 468,80 2007-12-16 -6 156,80 2007-12-16 -10 553,60 2007-12-16 -29 980,00 2007-12-16 -106 867,20 2007-12-16 -109 152,00 2007-12-16 -33 161,60 2007-12-16 -100 833,60 2007-12-16 -25 164,00 2007-12-16 -12 240,00 2007-12-16 -14 240,00 2007-12-16 -129 409,92 2007-12-16 -60 658,20 2007-12-16 -177 559,20 2007-12-16 -559 994,40 2007-12-16 -48 320,00 2007-12-16 -12 575,29 2007-12-16 -110 841,60 2007-12-16 -268 488,00 2007-12-16 -45 420,48 2007-12-16 -90 960,00 2007-12-16 -88 229,40 2007-12-16 -119 381,76 2007-12-16 -688,63 2007-12-16 3 480,27 2007-12-16 -26 329,57 2007-12-16 -1 624,80 2007-12-16 0,77 2007-12-16 -77 231,46 2007-12-16 -5 148,77 2007-12-16 6,67 2007-12-16 1,33 2007-12-16 5 529,60 2007-12-16 -134,75 2007-12-16 3 138,27 2007-12-16 325,00 2007-12-16 15,60 2007-12-16 15,60 2007-12-16 23,34 2007-12-16 -3 801,02 2007-12-16 33 364,80 2007-12-16 13 327,20 2007-12-16 6 594,23 2007-12-16 -9 640,81 2007-12-16 -960,00 2007-12-16 -11 527,22 2007-12-16 -1 244,16 2007-12-16 -1 198,80 2007-12-16 8 395,20 2007-12-16 4 766,40 2007-12-16 -10,73 2007-12-16 -426,11 2007-12-16 503,75 2007-12-16 2 145,25 2007-12-16 2 451,72 2007-12-16 2 414,27 2007-12-16 2 759,17 2007-12-16 1 126,26 2007-12-16 -1,12 2007-12-16 -3,29 2007-12-16 770,57 2007-12-16 -284,98 2007-12-16 -310,93 2007-12-16 550,39 2007-12-16 1 136,75 2007-12-16 206,67 2007-12-16 179,27 2007-12-16 179,30 2007-12-16 0,97 2007-12-16 347,25 2007-12-16 -1,18 2007-12-16 2,37 2007-12-16 2 334,63 2007-12-16 -11,20 2007-12-16 23,52 2007-12-16 2 184,95 2007-12-16 -0,22 2007-12-16 0,74 2007-12-16 -180,02 2007-12-16 -162,09 2007-12-16 362,50 2007-12-16 -969,29 2007-12-16 291,70 2007-12-16 -104,40 2007-12-16 -243,02 2007-12-16 -8,13 2007-12-16 -4,45 2007-12-16 -123,56 2007-12-16 -58 549,78 2007-12-16 -7 984,07 2007-12-16 -18 629,47 2007-12-16 28,42 2007-12-16 -468,75 2007-12-16 91,75 2007-12-16 -789,36 2007-12-16 -649,60 2007-12-16 -83,20 2007-12-16 -2 121,60 2007-12-16 -1 404,90 2007-12-16 -620,00 2007-12-16 -14,08 2007-12-16 -3 555,84 2007-12-16 -1 427,20 2007-12-16 15 943,20 2007-12-16 -470,93 2007-12-16 -180,02 2007-12-16 -272,00 2007-12-16 -8 263,87 2007-12-16 2 465,73 2007-12-16 -2 846,19 2007-12-16 -8 976,45 2007-12-16 -3 564,64 2007-12-16 -3 974,05 2007-12-16 -752,91 2007-12-16 -1 628,98 2007-12-16 -7 963,12 2007-12-16 -4 305,92 2007-12-16 -910,27 2007-12-16 -1 913,09 2007-12-16 -1 018,11 2007-12-16 -981,71 2007-12-16 -491,63 2007-12-16 4 898,79 2007-12-16 5 173,44 2007-12-16 5 173,44 2007-12-16 4 722,34 2007-12-16 -11 527,23 2007-12-16 -2 111,40 2007-12-16 8 884,80 2007-12-16 4 197,60 2007-12-16 -844,56 2007-12-16 19 065,60 2007-12-16 -245,95 2007-12-16 -66,60 2007-12-16 -399,60 2007-12-16 19 065,60 2007-12-16 8 884,80 2007-12-16 -4 223,30 2007-12-16 17 654,40 2007-12-16 -8 391,60 2007-12-16 4 442,40 2007-12-16 9 532,80 2007-12-16 -11 527,23 2007-12-16 -11 527,23 2007-12-16 -533,48 2007-12-16 -0,19 2007-12-16 8 242,27 2007-12-16 11 271,80 2007-12-16 -1 496,00 2007-12-16 -960,00 2007-12-16 -260,26 2007-12-16 3 311,56 2007-12-16 10 482,13 2007-12-16 2 349,57 2007-12-16 -2 963,20 2007-12-16 13 950,30 2007-12-16 -5 137,92 2007-12-16 7,36 2007-12-16 23,26 2007-12-16 891,08 2007-12-16 -67 155,54 2007-12-16 -12 071,90 2007-12-16 -5 322,03 2007-12-16 -9 118,95 2007-12-16 -7 353,71 2007-12-16 -6 967,54 2007-12-16 -3 564,57 2007-12-16 -1 085,93 2007-12-16 -491,60 2007-12-16 -654,44 2007-12-16 -1 912,98 2007-12-16 -752,88 2007-12-16 -6 617,41 2007-12-16 -2 781,69 2007-12-16 -910,82 2007-12-16 -3 444,56 2007-12-16 17 819,73 2007-12-16 14 097,72 2007-12-16 -1 016,40 2007-12-16 9 231,46 2007-12-16 1 083,16 2007-12-16 2 340,00 2007-12-16 -688,28 2007-12-16 1 555,12 2007-12-16 -417,48 2007-12-16 -847,20 2007-12-16 384,02 2007-12-16 384,01 2007-12-16 929,99 2007-12-16 206,66 2007-12-16 1 549,97 2007-12-16 179,21 2007-12-16 153,61 2007-12-16 929,99 2007-12-16 -10 875,25 2007-12-16 -134,75 2007-12-16 -700,96 2007-12-16 -1 656,00 2007-12-16 627,59 2007-12-16 -3,71 2007-12-16 -3,71 2007-12-16 503,51 2007-12-16 503,51 2007-12-16 100,70 2007-12-16 100,70 2007-12-16 17 335,22 2007-12-16 17 335,22 2007-12-16 17 335,22 2007-12-16 17 335,22 2007-12-16 -376,06 2007-12-16 57,51 2007-12-16 -0,03 2007-12-16 -115,26 2007-12-16 -794,78 2007-12-16 -891,17 2007-12-16 -3,35 2007-12-16 -2,40 2007-12-16 4,52 2007-12-16 -2,27 2007-12-16 21 146,43 2007-12-16 9 434,02 2007-12-16 -2 488,54 2007-12-16 -6 197,47 2007-12-16 3 874,98 2007-12-16 22 212,00 2007-12-16 -5 489,64 2007-12-16 19 065,60 2007-12-16 -2 797,70 2007-12-16 -11 706,70 2007-12-16 -206,74 2007-12-16 -340,21 2007-12-16 58 385,73 2007-12-16 -226,78 2007-12-16 24 208,42 2007-12-16 -1 674,79 2007-12-16 178 779,13 2007-12-16 -2 530,08 2007-12-16 180 895,73 2007-12-16 -238,53 2007-12-16 25 462,26 2007-12-16 -543,65 2007-12-16 58 033,56 2007-12-16 -488,59 2007-12-16 -2 556,35 2007-12-16 -2 536,93 2007-12-16 -749,18 2007-12-16 -354,13 2007-12-16 -457,02 2007-12-16 -1 347,08 2007-12-16 -543,42 2007-12-16 -4 660,72 2007-12-16 -1 965,49 2007-12-16 -650,21 2007-12-16 -2 439,05 2007-12-16 1 340 458,97 2007-12-16 -6 221,59 2007-12-16 -3 665,70 2007-12-16 706 922,32 2007-12-16 51 884,80 2007-12-16 15 800,00 2007-12-16 -2 364,29 2007-12-16 252 381,47 2007-12-16 12 396,84 2007-12-16 43 620,00 2007-12-16 -196,97 2007-12-16 34 067,75 2007-12-16 -330,04 2007-12-16 23 596,92 2007-12-16 -298,13 2007-12-16 21 315,61 2007-12-16 -332,62 2007-12-16 23 781,67 2007-12-16 -258,70 2007-12-16 18 496,85 2007-12-16 -1 085,24 2007-12-16 -1 085,24 2007-12-16 -648,33 2007-12-16 -144,07 2007-12-16 211 840,45 2007-12-16 -1 080,54 2007-12-16 -506,45 2007-12-16 -434,10 2007-12-16 -648,33 2007-12-16 190 857,94 2007-12-16 41 175,25 2007-12-16 37 124,75 2007-12-16 4 990,00 2007-12-16 11 700,00 2007-12-16 -494,78 2007-12-16 35 375,79 2007-12-16 -2 742,47 2007-12-16 196 081,18 2007-12-16 -2 742,47 2007-12-16 196 081,18 2007-12-16 -1 905,96 2007-12-16 136 272,45 2007-12-16 -1 905,96 2007-12-16 136 272,45 2007-12-16 -387,72 2007-12-16 27 721,02 2007-12-16 -387,72 2007-12-16 27 721,02 2007-12-16 -9 225,34 2007-12-16 659 594,12 2007-12-16 -9 225,34 2007-12-16 659 594,12 2007-12-16 -9 225,34 2007-12-16 659 594,12 2007-12-16 -9 225,34 2007-12-16 659 594,12 2007-12-16 66 321,44 2007-12-16 -232,29 2007-12-16 -361,75 2007-12-16 -117,45 2007-12-16 -216,11 2007-12-16 -561,57 2007-12-16 -634,23 2007-12-16 85 497,55 2007-12-16 -414,95 2007-12-16 29 668,30 2007-12-16 -1 246,59 2007-12-16 89 128,99 2007-12-16 -2 933,60 2007-12-16 209 746,68 2007-12-16 -994,48 2007-12-16 71 103,15 2007-12-16 -5 498,56 2007-12-16 -3 293,78 2007-12-16 628 635,41 2007-12-16 -1 764,61 2007-12-16 126 166,55 2007-12-16 12 466,87 2007-12-16 74 095,56 2007-12-16 -1 180,46 2007-12-16 84 400,28 2007-12-16 1 578 643,20 2007-12-16 471 719,30 2007-12-16 -1 927,05 2007-12-16 -113,36 2007-12-16 208 550,62 2007-12-16 -1 091,67 2007-12-16 111 580,20 2007-12-16 -3 243,61 2007-12-16 331 529,66 2007-12-16 -542,96 2007-12-16 55 495,76 2007-12-16 -636,91 2007-12-16 65 098,86 2007-12-16 -3 526,84 2007-12-16 360 478,30 2007-12-16 -235,12 2007-12-16 24 031,89 2007-12-16 -2 786,45 2007-12-16 284 803,78 2007-12-16 -557,29 2007-12-16 56 960,76 2007-12-16 174 873,60 2007-12-16 37 124,75 2007-12-16 -1 723,19 2007-12-16 176 127,92 2007-12-16 41 878,80 2007-12-16 82 690,09 2007-12-16 -453,56 2007-12-16 -355,47 2007-12-16 1 378 782,50 2007-12-16 -1 764,48 2007-12-16 180 347,85 2007-12-16 -1 586,99 2007-12-16 162 206,04 2007-12-16 49 280,00 2007-12-16 5 177,01 2007-12-16 460 754,05 2007-12-16 -614,57 2007-12-16 62 815,43 2007-12-16 425 671,20 2007-12-16 -3 463,51 2007-12-16 354 006,24 2007-12-16 -411,96 2007-12-16 42 106,07 2007-12-16 -1 327,60 2007-12-16 135 693,85 2007-12-16 660,54 2007-12-16 754,90 2007-12-16 989,73 2007-12-16 1 131,12 2007-12-16 314 729,80 2007-12-16 -182,63 2007-12-16 18 666,29 2007-12-16 -434,16 2007-12-16 44 375,28 2007-12-16 -289,04 2007-12-16 29 542,33 2007-12-16 -709,16 2007-12-16 -559,94 2007-12-16 -610,85 2007-12-16 -506,54 2007-12-16 243 923,74 2007-12-16 -551,95 2007-12-16 -100,35 2007-12-16 -352,77 2007-12-16 -352,77 2007-12-16 138 784,00 2007-12-16 -796,14 2007-12-16 81 373,57 2007-12-16 -166,95 2007-12-16 17 063,70 2007-12-16 -160,49 2007-12-16 16 403,67 2007-12-16 -130,71 2007-12-16 13 360,34 2007-12-16 -364,99 2007-12-16 37 305,36 2007-12-16 -307,43 2007-12-16 31 422,63 2007-12-16 -431,05 2007-12-16 44 057,53 2007-12-16 -1 062,57 2007-12-16 108 605,62 2007-12-16 -1 134,43 2007-12-16 115 950,65 2007-12-16 -79,96 2007-12-16 8 173,22 2007-12-16 -81,81 2007-12-16 8 361,83 2007-12-16 -72,52 2007-12-16 7 412,11 2007-12-16 -347,96 2007-12-16 35 564,98 2007-12-16 -485,13 2007-12-16 49 585,16 2007-12-16 -279,97 2007-12-16 28 615,47 2007-12-16 -52,27 2007-12-16 5 342,83 2007-12-16 12 229,17 2007-12-16 -119,65 2007-12-16 -96,57 2007-12-16 9 870,30 2007-12-16 -52,37 2007-12-16 5 352,78 2007-12-16 -58,25 2007-12-16 5 953,53 2007-12-16 -3 500,60 2007-12-16 357 796,38 2007-12-16 -477,35 2007-12-16 48 790,42 2007-12-16 -1 113,83 2007-12-16 113 844,30 2007-12-16 -133,11 2007-12-16 13 604,69 2007-12-16 -175,81 2007-12-16 17 969,56 2007-12-16 -281,43 2007-12-16 28 764,68 2007-12-16 40 432,82 2007-12-16 30 600,00 2007-12-16 339 068,32 2007-12-16 -253,28 2007-12-16 -122,72 2007-12-16 38 430,95 2007-12-16 14 512,00 2007-12-16 -2 708,58 2007-12-16 140 382,37 2007-12-16 -1 295,06 2007-12-16 67 121,33 2007-12-16 -3 549,28 2007-12-16 183 954,67 2007-12-16 -11 193,88 2007-12-16 580 164,73 2007-12-16 -1 868,36 2007-12-16 -994,51 2007-12-16 -950,82 2007-12-16 -491,16 2007-12-16 1 203 090,86 2007-12-16 -3 518,65 2007-12-16 -3 894,41 2007-12-16 -753,72 2007-12-16 -1 558,63 2007-12-16 -4 052,10 2007-12-16 -4 228,63 2007-12-16 -901,82 2007-12-16 648 370,43 2007-12-16 465 931,07 2007-12-16 570 175,20 2007-12-16 441 295,20 2007-12-16 51 477,52 2007-12-16 1 212 001,70 2007-12-16 1 943 899,20 2007-12-16 465 931,07 2007-12-16 465 931,07 2007-12-16 26 541,80 2007-12-16 11 890,44 2007-12-16 -4 391,80 2007-12-16 227 621,53 2007-12-16 -3 814,22 2007-12-16 197 686,26 2007-12-16 73 780,00 2007-12-16 62 115,55 2007-12-16 -2 115,54 2007-12-16 -5 075,98 2007-12-16 -847,37 2007-12-16 416 645,71 2007-12-16 292 721,98 TOTAL: 7 633,80 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding a number of values that adds up to a specific value
see:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu200762 "Andy_0093" wrote: I have a column with almost 700 cells containing different values. The column total should equal zero. Now I have a value 7633,80 instead of zero. I know that this error comes from say 2 to 20 of the values in my column the others should add upp to zero. How do I find which values that adds up to the "non-zero"-value 7633,80? See my data below. Doc. Date Amount 2007-12-16 -21 869,40 2007-12-16 -36 000,00 2007-12-16 -24 872,72 2007-12-16 -109 948,80 2007-12-16 -166 293,75 2007-12-16 -19 901,70 2007-12-16 -48 370,96 2007-12-16 -27 091,20 2007-12-16 -173 250,00 2007-12-16 -175 284,00 2007-12-16 -51 729,60 2007-12-16 -24 473,60 2007-12-16 -31 564,80 2007-12-16 -93 053,40 2007-12-16 -37 557,52 2007-12-16 -321 954,75 2007-12-16 -135 781,80 2007-12-16 -44 928,00 2007-12-16 -168 504,00 2007-12-16 -456 429,60 2007-12-16 -272 522,88 2007-12-16 -50 868,40 2007-12-16 -15 800,00 2007-12-16 -259 248,64 2007-12-16 -13 480,00 2007-12-16 -14 700,00 2007-12-16 -31 260,00 2007-12-16 -33 182,50 2007-12-16 -24 822,00 2007-12-16 -20 600,00 2007-12-16 -40 840,00 2007-12-16 -76 891,50 2007-12-16 -76 891,50 2007-12-16 -46 635,75 2007-12-16 -10 363,50 2007-12-16 -77 726,25 2007-12-16 -35 882,70 2007-12-16 -30 756,60 2007-12-16 -46 635,75 2007-12-16 -30 300,00 2007-12-16 -36 990,00 2007-12-16 -241 639,20 2007-12-16 -121 913,40 2007-12-16 -80 364,96 2007-12-16 -87 094,80 2007-12-16 -400 626,00 2007-12-16 -891 432,36 2007-12-16 -322 372,80 2007-12-16 -468 921,60 2007-12-16 -183 330,72 2007-12-16 -10 784,16 2007-12-16 -113 968,80 2007-12-16 -301 956,48 2007-12-16 -53 328,00 2007-12-16 -64 462,72 2007-12-16 -279 720,00 2007-12-16 -18 648,00 2007-12-16 -282 024,00 2007-12-16 -56 404,80 2007-12-16 -180 403,20 2007-12-16 -36 990,00 2007-12-16 -177 543,00 2007-12-16 -33 850,00 2007-12-16 -8 369,40 2007-12-16 -45 920,00 2007-12-16 -36 000,00 2007-12-16 -51 817,50 2007-12-16 -56 999,25 2007-12-16 -10 363,50 2007-12-16 -35 882,70 2007-12-16 -35 882,70 2007-12-16 -80 578,40 2007-12-16 -17 244,00 2007-12-16 -16 242,00 2007-12-16 -13 232,00 2007-12-16 -39 275,00 2007-12-16 -31 104,00 2007-12-16 -43 650,00 2007-12-16 -109 728,00 2007-12-16 -114 816,00 2007-12-16 -8 094,00 2007-12-16 -8 100,00 2007-12-16 -7 177,50 2007-12-16 -35 579,52 2007-12-16 -48 130,74 2007-12-16 -28 627,20 2007-12-16 -5 186,16 2007-12-16 -11 866,50 2007-12-16 -9 765,60 2007-12-16 -5 295,96 2007-12-16 -175 284,00 2007-12-16 -193 974,00 2007-12-16 -37 557,52 2007-12-16 -77 594,40 2007-12-16 -198 000,00 2007-12-16 -210 630,00 2007-12-16 -44 928,00 2007-12-16 -93 053,40 2007-12-16 -49 531,50 2007-12-16 -47 347,20 2007-12-16 -24 473,60 2007-12-16 -140 652,60 2007-12-16 -196 049,70 2007-12-16 -196 049,70 2007-12-16 -135 586,44 2007-12-16 -454 403,84 2007-12-16 -342 858,60 2007-12-16 -160 250,40 2007-12-16 -78 037,20 2007-12-16 -137 143,44 2007-12-16 -322 372,80 2007-12-16 -40 000,17 2007-12-16 -11 164,80 2007-12-16 -66 988,80 2007-12-16 -322 372,80 2007-12-16 -160 250,40 2007-12-16 -685 717,20 2007-12-16 -319 060,80 2007-12-16 -1 406 764,80 2007-12-16 -80 125,20 2007-12-16 -161 186,40 2007-12-16 -454 403,84 2007-12-16 -454 403,84 2007-12-16 -26 008,32 2007-12-16 -11 890,25 2007-12-16 -231 472,00 2007-12-16 -205 143,84 2007-12-16 -72 284,00 2007-12-16 -4 289,04 2007-12-16 -10 044,00 2007-12-16 -35 508,60 2007-12-16 -193 335,00 2007-12-16 -193 335,00 2007-12-16 -134 870,00 2007-12-16 -134 870,00 2007-12-16 -27 434,00 2007-12-16 -27 434,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -667 704,00 2007-12-16 -16 000,00 2007-12-16 -25 560,00 2007-12-16 -8 280,00 2007-12-16 -15 120,00 2007-12-16 -38 794,80 2007-12-16 -43 821,00 2007-12-16 -29 250,00 2007-12-16 -87 880,00 2007-12-16 -206 817,60 2007-12-16 -70 106,40 2007-12-16 -408 784,32 2007-12-16 -617 145,48 2007-12-16 -564 152,40 2007-12-16 -240 375,60 2007-12-16 -185 177,60 2007-12-16 -150 978,24 2007-12-16 -48 320,00 2007-12-16 -454 403,84 2007-12-16 -60 956,70 2007-12-16 -200 966,40 2007-12-16 -156 074,40 2007-12-16 -80 593,20 2007-12-16 -350 532,00 2007-12-16 -41 268,00 2007-12-16 -134 870,00 2007-12-16 -61 593,84 2007-12-16 -70 392,96 2007-12-16 -91 489,86 2007-12-16 -104 559,84 2007-12-16 -19 609,92 2007-12-16 -43 940,00 2007-12-16 -29 250,00 2007-12-16 -72 544,50 2007-12-16 -56 387,10 2007-12-16 -61 513,20 2007-12-16 -5 771,72 2007-12-16 -295 746,00 2007-12-16 -40 329,00 2007-12-16 -94 101,00 2007-12-16 -13 500,00 2007-12-16 -17 325,00 2007-12-16 -28 575,00 2007-12-16 -3 425,76 2007-12-16 -5 779,20 2007-12-16 -9 468,80 2007-12-16 -6 156,80 2007-12-16 -10 553,60 2007-12-16 -29 980,00 2007-12-16 -106 867,20 2007-12-16 -109 152,00 2007-12-16 -33 161,60 2007-12-16 -100 833,60 2007-12-16 -25 164,00 2007-12-16 -12 240,00 2007-12-16 -14 240,00 2007-12-16 -129 409,92 2007-12-16 -60 658,20 2007-12-16 -177 559,20 2007-12-16 -559 994,40 2007-12-16 -48 320,00 2007-12-16 -12 575,29 2007-12-16 -110 841,60 2007-12-16 -268 488,00 2007-12-16 -45 420,48 2007-12-16 -90 960,00 2007-12-16 -88 229,40 2007-12-16 -119 381,76 2007-12-16 -688,63 2007-12-16 3 480,27 2007-12-16 -26 329,57 2007-12-16 -1 624,80 2007-12-16 0,77 2007-12-16 -77 231,46 2007-12-16 -5 148,77 2007-12-16 6,67 2007-12-16 1,33 2007-12-16 5 529,60 2007-12-16 -134,75 2007-12-16 3 138,27 2007-12-16 325,00 2007-12-16 15,60 2007-12-16 15,60 2007-12-16 23,34 2007-12-16 -3 801,02 2007-12-16 33 364,80 2007-12-16 13 327,20 2007-12-16 6 594,23 2007-12-16 -9 640,81 2007-12-16 -960,00 2007-12-16 -11 527,22 2007-12-16 -1 244,16 2007-12-16 -1 198,80 2007-12-16 8 395,20 2007-12-16 4 766,40 2007-12-16 -10,73 2007-12-16 -426,11 2007-12-16 503,75 2007-12-16 2 145,25 2007-12-16 2 451,72 2007-12-16 2 414,27 2007-12-16 2 759,17 2007-12-16 1 126,26 2007-12-16 -1,12 2007-12-16 -3,29 2007-12-16 770,57 2007-12-16 -284,98 2007-12-16 -310,93 2007-12-16 550,39 2007-12-16 1 136,75 2007-12-16 206,67 2007-12-16 179,27 2007-12-16 179,30 2007-12-16 0,97 2007-12-16 347,25 2007-12-16 -1,18 2007-12-16 2,37 2007-12-16 2 334,63 2007-12-16 -11,20 2007-12-16 23,52 2007-12-16 2 184,95 2007-12-16 -0,22 2007-12-16 0,74 2007-12-16 -180,02 2007-12-16 -162,09 2007-12-16 362,50 2007-12-16 -969,29 2007-12-16 291,70 2007-12-16 -104,40 2007-12-16 -243,02 2007-12-16 -8,13 2007-12-16 -4,45 2007-12-16 -123,56 2007-12-16 -58 549,78 2007-12-16 -7 984,07 2007-12-16 -18 629,47 2007-12-16 28,42 2007-12-16 -468,75 2007-12-16 91,75 2007-12-16 -789,36 2007-12-16 -649,60 2007-12-16 -83,20 2007-12-16 -2 121,60 2007-12-16 -1 404,90 2007-12-16 -620,00 2007-12-16 -14,08 2007-12-16 -3 555,84 2007-12-16 -1 427,20 2007-12-16 15 943,20 2007-12-16 -470,93 2007-12-16 -180,02 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
Finding cells with a specific number of characters | Excel Discussion (Misc queries) | |||
finding specific values in a within a file | New Users to Excel | |||
Formula that only adds numbers that meet specific criteria | Excel Discussion (Misc queries) | |||
Finding the max of a column where values less than a specified number | Excel Worksheet Functions |