Förenklat
Antag att du har saldotabellen i två kolumner (A och B):
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJ4AAACECAYAAABhyJKGAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAtrSURBVHhe7Z3PaxvpGce/6l+QbAgkNfkBkXwwOiwUm10JQtmT5UDxskYshMWHJdJCaOTSuCxB7SFrllAt1AoUKi05mGAIItuYgq2UQLsEJIx9yUH4ICklcfAmS4ibSy45xPu+M6+kiS3LM2N53pH1/cDgeWdGst7R932e9x09z/sGXr9+vQVCPOZX6i8hnkLhES1QeEQLFB7RAoVHtEDhES1QeEQLFB7RAoVHtEDhES1QeEQLngjvyJEjaq8/2drq75/D29XfE+Ftbm6qvf6EwtMkvHfv3qm9/oT131l/T4THFs/6b+dAhPf27Vu1Z8IWz/pvp+vCk6J78+aNKpnobvErNycwcXNFlbxHT/1XcHNC1Lu5XcW9DXXKYw7c4rUTnURri9+4h8L6eZxfXxZfhR701f8sLmbv4u5dsf3pNOb/dg86tHegFm830Ul0WryNlRIQ/QyfRddR0NTkdVt8g4FTQoZ6ODCL10l0En0tfgOG7kYGMDASBUorvmnxXmM2wBEMqLKXHIjF20t0Em0tfmMFJUQhdCda/IjYK2FFg/L0WbwnmE+ZfbxUKYo/fKpDdgdg8eyITqLrxr/fygdgGj3vladPeJY+XvwZUhM3tfRzuyo8u6KT6HE1K/hh/gmezKeaI7uUUf7B85vvB1eLkY9wHuvY0GDxu+ZqnYhOoqXFryzj4dmLyMrW3tyyuHj2IZY9Vp4+i2dB3g+cxoAGb9sVi+dUdBIdLX5l+SHO7uhMS3d7Fg89Vp4+i9fq4038dV243SsYUWe8pF39Hc0k4ER0R48eVXvAy5cvcfz4cVXqP1j/nfW3bfHcWLoGvujjaIT136fFc8uLFy9w4sQJVeo/WP+d9d/X4xS7sMWz/tvxRHi+GNVphPXfWf+AOLgl3K1xcvsmldqN42tra+rfEWLiSR/vwYMHxpC+X3n69CnOnDmjSv1Hu/p74moJ2Q6FR7RA4REtUHhECxReT1FHNhpAsqiK7ahnEQ0k0ekSP+BQeGYCyVVdWSPk0GBbeBv3rmJiYhmnLuqK3CeHCdvCG/j0O9y9u9+wmjauwuoaxH5SnA8EomILIJrMilc0UK/NFs1rGm/S8TX+pJ5NijrLzyy2aBJZ6wd2Wp/m9eq9aup4E3HfkuZ7Na4p+uAGedzHC+JCPIL8Qkt59cUCyolxxOQNyhSAtPy1oyS2GuKVKWS2dVbyhQWMz9WwlYuJkr3X+AohlMkp+ZHVLztpoCA+sKkFp/UR14s3q8TF/ZDvVZrG4MIUyuqscT4aQmEojZr6f7V4BWOT+hun54OL4IU4IvkF1fmtY7FQRmJciiiIVK4EQ0/yjLgzg2GgUn3/FiXSOcSCQVWy9xpfERxEGHnMCMttfMpYDiVRAbNGDutTX0ShnEA61bofselZRFSpdb7x/uKKVBqJsv7G6bnwhPIQj+RhGD11YwzdyWLRdEFR4Q4ymQxmKubxTrh5jV5iyNWWEF+bwWTDPVp05ag+tTWLdbNLCENNZerDe+HJVp1OGO625WYF0gWNmS6oVMohl8shLVp7R9y8xg8EY4ZlK0nXJ1ztVMP1Oa1PaKhl3WxTw5pztXYdDcITxMaREO42I+6A6WbbUC9iIa/27eLmNV4jxBWNtvpYhgssrwk5tGGv+ijvMdM0mXUUM5Y+3o7z8t/PIB+ZxfQut90r9AhP2LjxRB75fMvNis4H0gnR8TXcTBTRDDCUUOd2w81rdCM/c7iAkPGZhasVvnR2SfRbG+c61kcOzhKojInzhpiE95ibRbgQUiPWDKrjlj6ePF8SA5S1yeaoNlQIY2kuZQpeIwyL8gCGRTEsivgECo9ogcIjWghUKpUtmSvRyJewu2/32j+W/mH8o//+3u/DTeIlAdHxO9DBxW9vXjL+/u+7fxt/+xEOLji4ID6BwiNaoPCIFig8ogUKj9hH/s4ciL4fuCpoRNQ4CTS1Lbxnq9eNEaq53XIRjkN6mXpRiG7SGmSqEKILjVUQrzkLNLUpvEeYf/U7/Hjle2O7/fEGrt1/pM6Rw08RmZk1pNPWAAST4kIekdk5NGJRg6kStkp7ByHYFN6H+Hr0Q7UPnDo3jMFXz/FMlR0jTHav5Un0NzHkSjnEQqrYpI5qBQgPOo91cdfH+/9PqB47iVOq6IwezJMgu6CCSqvbEo662cdrsllEYhH41mIBndGDeRKkI3lhR8bnpCGpYSlcaUVUd8CR8IwBhrBMf77ypYuQ6xa9lydB2mPmbyTSKcQMbyuTjeKI7BZRbcG28KTovsEl/Hgx5tLFKno1T4K0IejaW9kTnnCv34hRbX74pDrQRXohT4LsSmw8gfJURvXrVM5HZEjYws7YE54cTFT/bnmOJ7fruLOpzjuhF/Mk+h3jwbEYOITkc7wypkJyIKFmf4jlUFsCCsaxEMYqCSzZeJzCsCgPYFgUw6KIT6DwiBYoPKIF5lwQLXBw4QEcXHBwQXwChUe0QOERLVB4RAsahFdEMrDHWg3En+jIuSjft/xOO190H31MehJNORfPsX7scjPn4ttj/8QXzLnoI7TlXJzE58OtiONI6CO1tw+qar2KhnlWh4kf8UnORbm2jNGQ29B3k3yhiulSI1w6jzF2+noQL3IuHt9q9vEehr7H1+fUcZfIcGmznQSNYEI0174gvcbB5lyc+7LZxztf6/IAw9W0+UQ/HuRcWImMXsboq5+6JzxXC4UQ/XiQc3HnsdoXPFv9F+4f+/W+kn4qcoEVY69ujIzQWGiF9BQHm3PxwUk8WWw9x/uiOozb+8o2iyA+XkXG6JDKOP1Z1BqJtsR/MOeiN2FYFMOiiE+g8IgWKDyiBeZcEC1wcOEBHFxwcEF8AoVHtEDhES1QeEQLFB6xRTFpTpQut90mS69n5TX2gnpdCO8RboiR6g1L0AA55BSTGMuHsWTkVZiTpYe2B+7KmV6n7McYORaeEZmi9kl/YOZVTDdj7i7Ed0ZPFjMFhBP2Z9h0Jjw5JW11GF8NqrJb6pZ8i0AUSTux0kQbsdwWSo1sHuFkFwtlRIYsgU/C2s0gjdy4KtvAgfCe405xFZ/EYjitjrijjuzkGCrxmvHLxlYtDUyFmGfbAxSTZuhTIbyEOYsQs5MFxKedhbXZFl75/l/wn8FL+PwDdcAt9UUUygmkm/lwMeSEABmO53+k5ZN9vDTGWn28YgZT4XQzvdEu9oT3+Bau4XJ3Zn1nmHuPI/MqZhExkrNEl2msglmH1k5iQ3jCxS4vA5ZZ369VgfuLl5BYfa6ucQATe3oM4UpFf7xtV6heRaUZkSy2MRkIkjdm9N+r6+QqSEBOZ2E3xXFnkICsiOgniD6e2WE1y2vpw+tuez1IQPbtjPQEI6S9Lsoh4WyXsLX9CysmhfiApa3ce/kzPgkSCCI1t4RwIaRGtWZnlX08/xLLyXzZAkLq+5rB/nNkGBblAb1u8faLTyweIRQe0QSFR7TAnAuiBQ4uPICDCw4uiE+g8IgWKDyiBQqPaMEfwjOmweIE3L7H+J52rnNhJx9jO7aF92z1ejM6xdi43EBf0Wmdiz3zMdrgyOKNXjDnQDa20f3N+k56ib3Wueicj9EO+xbvVRfX8hEm+73p6feaqZloZrd1LmzkY+yCI4sngz9NV3trH1HEMkZ/qpVzUZrG4EIbE056ivb5GLtjW3iR0Zabvf3xBq65XW5ge85FI5RalUhv0jYfowOOLF6DU8OX8BVWUdpUB5zAnItDjDUfozOuhAf8jCevBnDaTcYZcy4OER3yMfbApvAe4Ybl8Ykxm8Dgb9wJKHgB8UgeM82HQWptBFUivYS5wEp+pvHsTn2XNtYssW/xLFlmxjoXrh+nyJyL2VbORTSD6jj7eL7GeHAsvqs261y4zcdgWJQHMCyKYVHEJ1B4RAsUHtECcy6IBoBfAOtU03kcYEQUAAAAAElFTkSuQmCC)
Sen har du en beställningstabellen med Kundnamn, prio osv i kolumn D:I
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAegAAAElCAYAAAAvJnFmAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACzuSURBVHhe7d1PiDPpnR/wr3Ly0QR88WCPyZYa3OiQsMSYEoTklEh9acMgAs6iQ9iqvWSkBbdPSg6JDstoDqUJgVXtqdnspTywItAq55RgkGLsQ3IoZOiqhJ4144tJ8NEnK8/zVOlvd5Wkd15JT+n5foyYVuvtdv9Uz1O/p57nUf0qv/vd7xYgIiIirfy97L9ERESkESZoIiIiDTFBExERaWhrDfqLL77A17/+9eyZecR7gQ8//DB7Zp7FYoFKpZI9Mw/jNzt+Og77y+nj37qC/sMf/pB9ZSbT45cNzmSMn/tF6XDsL6ePnwl6A+Nn/CYzPX46DvvL6eNngt5gevwcETN+okOxv/AK+qwYP+M3menx03HYX04f/9YmsV/96lf45je/mT07h/+Fv/jsP+Gn2bPUt/Bn/+rf4V/+/ezpGf3mN7/Bd7/73ezZufwCn330CX6WPUt9Bz8cfooffJA9PZPf//73+NrXvpY9O6fX78F3fjjEp2d+Ay4Xv3gHPvsIn2y/ARh++gOc8x24ZPx6ke0xwLde9cG875vpsu1FHouf4/uff4zvZd85t3PEr8EVtEzIf4X//nH2uPsAf/mf/xR/8b+zl8/ociNCmZA/x+efLx+XOQFcdkS8/R6cOzlLl4lfnmg+QvCt4cbx/xw//vav8WX2L87lssefysb09nKO+PWb4v6jfy2S9Pfx05+H+HX2rXMxvcFxTen88f/is0/wd2/MFnzv4/NfGXANmo7B88Xp49dzDfqP/hj/4v/+EtP/lz0/E44IGf95/QI//9l3UP+eHvOlph9/Og7PF6ePn5vENlwu/hf8TecjfPTR8vGZOHWf32VHxNvvwWcXeAPOHv+XX+Lv8G18sMrPX+Jvf7R8D36Evz3zHDevoDft9kn52N0rYjZeQZt6Ba18gG+feaPY5eLfXYO+zMaHy3a47ffg4wu8AWePX2Tmb2dfpj7ADz6V8f8Y/yT7zjkxQW/a7ZOXOy66YoI2NEH/+pf/BT+9+WPY2fNz4QwC4z+vD/Ct7/wMwbkvlXOYfvzpODxfnD5+7RL0r3/57/En/wP4s+/9w+w752N6g+OI+NzxiyvmP/8h8Dedi0zp7+IVNB2D5wsjrqB/rT5W9U8/Sx9/8vyP8dcfX+Zz0JdL0K/Xuy5xwjZ9gHKR+D/4AT79/MfAJ5vHX+7s/vOzf9TO9ONPx+H54vTxb92oZDqdolarZc/ME0UR6vV69sw8v/3tb/GNb3wje2Yexm92/HQc9pfTx89d3BsYP+M3menx03HYX04fPxP0BtPj55oS4yc6FPvL6eNngt7A+Bm/yUyPn47D/nL6+Fdr0P/oP7TUNwj4n/82yL4yy5dffokP1nfNMA7jNzt+Og77y+njr/zkJz9RCfrHP/8r9Q0CPvn+n2ZfERERXUZlkU2k/4Mf/XP1jf/z6X9V/zWR6e/BF198gQ8//DB7Zh7Gb3b8dBz2l9PHv7UGTURERHpggibaK8n+S0R0PkzQRIUShG4bbii+Cl3UxRdM10R0DkzQRIUsNEZTjBriq8YIU/GFlb1CRHRKhQk6dCuoDzeuF5Ih6pWKupo4CfX7XZzq1x9Lxl8R8a4e9f1/WxIOxfvDa6yrIdqkW99uA5td4qtJMBS/+2T96Z2lf9dW21/FP1QzCNvtfDeOA+I6uK8f/x6xD9K1OOIKWnSUdhfwYnU1YQpbxCs3ui8WMbyaj2Z2gsoTj7vwx3H2jEotdFGpijbfW7aBBeIeEFR1TKrvk4XONI13EXuw4WCSxb+YdtQMgs7tnH2w/JKhGAi/x0HW+/5953Jwgg7dKrq1CaYdUyf4xEnr3gFmcxR1/cZInMRMGsFcLTEg7ftqgDZqrNu8nOZ+9Gz4/eKB2rXTuZ1/tb8tvWLfmjmks4vnPoLn7Ml78L5/37kclKCTYR1NX4yitxp9CLeycyWxNW21nJoS/3Xr2RRZHe7OlPlq+lBOHZZq0JvFNxTvg4wheyNeLQvIf7eKP41T/4Hc8thlT6XNY7s6bmlcdXczWb39vhT/jIaSJwQzG6271wNS664FexbgSQWwfK82j/N2O5ejd7k0tDz+ued+9R5vvO973rODf+8JvG7ne6xiyf7W3b6eZO1FxSPev9xOsv/93v7b9v97OVMiq9ipR6WKeW9h8IXIu8re51f9Pv+4vt1+09/T9MW1ULcqXpPnnAOOofw3b55n3/p95bE/Qc8HSGe2R3iXManfH+DmYZpOj01q8LuDdQIXvzhqZdOH0wfcjLuYqdd0JP7esTjK9i2q2XckPxjj/lHE8OaIXTaOKoLbHuJsijBuRWi2db/6snDXEleJ43VTTp4CzJx70QZETIMAECexxUIe1xitqIvBTqvffl8O+xn91HDz1nnauhGvzDDfSDK57VwkJtl/etnxX8gpchH46+MvTmRyOn21hLTnPTv49+pAxFLY1+XrzfXrch2h2S4ccOSfV96W/+/F+96M0HqcqnK704lj/OzIV/Gq3+cd19z2my6viMOQLS+u805hLsk9z+b/vjLYn6Bvb9XJKEgvF47m9MQbsjzJNe7hIMKzOkDyCsVBbzVStdB4kOtdeklHXXJUVkU3cjDJ1uCW0vhyRturGNc7f61OD85M/+SkrhL98aoDPAUzOPeyaYsGn+1qVq+IY3lTAyJ1UNe235fDfqbMctu5SuY++uLKQkX75k5weZXRhO9sLiHtec8O+r2a2NfXd1+3Grh3is85ue93jvzz0DMiu4XVREn1FvaeZSzKt9Xvi47rO7Tf/GNY3vPsPgdMcd9hFHuASFRbU55fVTzX+Gp5bb1JTDymooFk3393VdzqNgp5i3WHlu1DXURnHUDlZ/lUTgmKQUu97mIwGKAfpd8v8i4/c3k5J315Uhfp5XZzKiVXQ/SfCVrzPtrZ1NvulWHU78Of2fAetltX8Xu2//dqY19fV6+Lk/Vymlk85JTkWchEsVquEOTfsjNLRu+o8Lieuv2W5Dy7x2GbxKxOujGm+R7n7+VINfvSLDHmZRiZyCu4nqOmudfT24KcmmqmU1NTMWAZjUboiSu7Qu/yM5emBihvX8Wp92PzqmsfceUgr4ancuqtJ8a6O0sctd4UE3Fl0a1u9K9D3rM9v1cb+/q6el1cAckp5uwhB8TnWQduQFzMi/c+SyJ9YPK4PUtG72jfcT1p+y3LebbYYQlasDryJLL5MaN0hLKepkwQDsSJK3u2V3aF1l8Nm+TP67wG/Q5exSjPu+Jqyfawc7GkJzmN5I8xEC09nd5+QxJCLs0f5V1+5uzSAYpc4tja2CKuattd8X70DjyJi0Rb3/honvqZN6ZQG6MYnmgruR/j233PDvy9WtjX11ezNRuvn+tjMXIgFLQQL5ZJZGMalb6aouP6Pttv2c+zBQ5O0FJjNFHz+m31RqQnMDn1ne6aG+D5vnXEVbH4+UcPtWDz5/Vbg/5qRIzTGK15O1vHrqAa1Eo0QpdrRj58fz29LWdTek6EpohFXXEMgFvRDAq9y8/ooDFSnwNGf7kPQRw/cYXViherteG9ZOy1AFUVu/gd/Qje5K2lkrSteOiiKteS9r1nB//ec5CbCh1ETfG3ZOeG3efFfV2+Ptl4n6voz29xpzLl7u96z+TJXb7n6v83fcjE8T5X88xVcFz3tF+5RyHNLYfM2u4/zx73+/TBcpMbWG6S5eMYv2Hxy3X+8T0eVxuUxFWeKxLJbcyPWu3B/sJyk2clE7PJAxQi0yTP0XUtq9FVYYIW5JXz7oOIrp/VeYSHfjbVKjeKtcXV8wSPvHomDTBBE5HBLLWTWO0uXu423vg8LdElVV5eXtQa9D/7j2XYtfP+ySntt66Y/9u/0X6bMRERXbFXm8RMk5egTVyL5qYPxm9y/HQc9pfTx79K0JKpbzgTdIodjvGbHD8dh/3l9PFzDVqQyVg+5LT28msiIqJLYoImIiLSEBM0ERGRhpigjSHvkLQuaL5b/J+uiLzPcaW+Ux2Ix5+Ow/aSSobyfbjMLUKZoA2RDNto+jVMYlk6My3+n95Tna5JEork3H5ddIbHn44Sulvtpbe8R7xpZDGV7uXuNccEbYh4PoPtPWSVemQBAhuz4IlXUVclxKA/R6/3uugMjz8dQ94CFbLEbNZeGveOLF1oXHuRFRprzuXuEZKfoMUIqrJRDkxd5ps4groSjdEb9XVrN8V3TBKjR1dWmqmkU12cFtVdAyNZLrGaPd3wTsefjGXd1AB/jLRSZIJw7MNu3ZnVXsT5r48eRvfZ8wvIT9CNB1X6biBzsrrMr2FycI090luCp0BcUd2+cSZfSTAUo0f05BSXvBViOi2q2gOV3CHHn4zWGGHiRWhW5QC9KhKVafcnF+e/doDWhQtKF0xxpzVco74Ld9BF7WK1Zul9k+X0umL4Vdzh0nsUL8dkiRhJy0F19Mxr6LI77PiTyeSMaTNoIV4s16CbZq1BhwN0az1cuosUr0Groto+/GijYD+Vmup4voPJdF3MPE8ia+XKqe26i8FggH6UvUCldczxJ1OlMyxOb9lGLDQePNhyyls9v3Yh3GYE78JXz1JxgpZz8KIzO7UIfe74LD15cq7KpYrFAbMhclmjKWe4ZZWfEUajkRisZa9RKR11/IlMlTxDVgnvqul98WjKwkk+muLrc08iFCRoOQefTm2PRj3Uuu2dz1VSmaxOzvE7npyTEGMW+Cqtr3z8ySCWWs7y+8tNoQnCQRczuatbPb9yVgdTNbWfPSZyF7cjBraL1ZLfueQmaPm5yW5tkv1BDTx4QLfNXbzlFGKgPssnRoHLUaF6FHz4Xi5vOJEaNapC9gPg1syKpOWRyBuUiONalZ+DXl4ByGP8DsefjNYYxZjUAlRVO5GbxDzE3CR8dqxmtYHxM37Gb278dBz2l9PHX7wGTURERBfBBE1ERKQhJmgiIiINVV5eXlZr0ERERKQHbhLbwPgZP+M3N346DvvL6ePnFDcREZGGmKCJiIg0xARNRESkISZoIiIiDTFBGyNB6NZXt3msu/tu2xrCFf/OpApzV0Pd8rP+9r3zi14j2nDc+eL66BA/E7Qh5L3Vm74slpDWd21FXbR5lr46SSgScFvei/u1oteItoTu1vmih65h9aC345fny0vEzwRtiHg+g+09oKEKvFq4a9mYBU8sfnJVQgz6c/R6HuzsO2tFrxFtS54jQFavys4XjXsHiJ6NOV+EY//V+fIS8hO0GEFU6uvLelmursL5ztJqjBaYdnZK9NduRNPb4zmEW0+neSp1Vj/SWwOj6QiNavZ0S9FrRNssVW9yjFAlgCRNWK27/eeLK7F9vkzwFIgLnNvzd578BN14gIcuBvKMLIv3y1qyLDd2JQ5vcH7wjIdpOs0zqflocpBGdP0aI0y8KCtPKstNTvC4O8A3QOim8Qe1y8RfMMVtofPoIeq7cAdd1CYs9H4tQrcqhl7eQQ3O6XWyUXM2zSVH1eo5EV0rOWPaDFqIF8s16KZZa9AZeSV9yfiL16Bl0X5x1eRHDu6Zna+C6ni+g8l0mXiPUL3l+iXR1Utn2LYG5w8ebGMH55eLvzhBJ0P0xcncqUXoc8dv6cnkXJVLFYt3nA2J59wBTERXLsGwrsdHTAsStPgj2+nU9mjUQ63b5mcnS2yVnOPjknM0DkVLkNKNImpnp3pORNfJgtoj1l9uEhZ9f9DFzJi+r1H8sprVkiw9uRR79gLOJHuWPbe9RZw9v0ab8V+XycIRh1oe7u2HI15Z245f/oy98CbewrGzf8/jr7fYW9h5x7jotcz1tn86XryYOOKcn7UV23nd96+7vegRP8tNbmD8jJ/xmxs/HYf95fTxF69BExER0UUwQRMREWmICZqIiEhDFbnQnX1NREREmuAmsQ2Mn/EzfnPjp+Owv5w+fk5xExERaYgJmoiISENM0ERERBpigiYiItIQE7QxEoRuHZWKrG9aQd1d3meWrk4yRL1Sf3Xv/GToiu8vj7+ZdYnoDWwvb9IhfiZoQyTDNpq+LJaR1jdtRV20Wf3k6iShONm2u6+rjomTcLsboSWPfzxBzW9qUa2HLovtJYcm8TNBGyKez2B7D2ioAq8W7lo2ZsETr6KvSohBf45ez3tVtzt5CjBzeujI4281cO8A/pgZ2mxsL3l0iT8/QYcuKvX1NKgsV1jhkLu0GqMFpqq1bajdiFRdIAnh1tMpnkqlDpdX3JprYDQdoVHNnm5QA7Tb9QvVW3FKjp45QDMa20seXeLPT9CNB3joYiBzsrrcr2EyYiXg65DgKdhugK/JeuBNRK1YliTFIu4B3SqnRUspwXOUfZmxZMFbojeZ3l70ib9gittC59FD1HfhDrqoTY4r9E/6Ct2qGHp5eNy9ot6UPCGYOegt/40lRtsiUXOMRkR0HsVr0FYHvZoPP3JwzxPzVZBLFU3fwWTaKZ7ejuevN45QSVnYvQBIdi8RiFZMby/6xF+coJMh+uJk7tQi9Ln+WHoyOVflUsXigNmQ6u2rjSNUXnINbTaPs2fpGtvePQhkLNPbiy7xFyRouQaZTm2PRj3Uuu1Xn5Oj8lgl5/jApQrrDi3b3xiYifZQr3ANuqSsuxZsv5/24STE2AccTotRDtPbizbxy2pWS7L05FLs2Qs4k+xZ9tz2FnH2/Bptxn9dJgtHHGp5uLcfjnhl7VX8sfg5e/3v7Y32cI1Kf/xjb2FvHV/5WB/j2HNWr791LK+3/dOb2F4K6RA/y01uYPyMn/GbGz8dh/3l9PEXr0ETERHRRTBBExERaYgJmoiISEMVudCdfU1ERESa4CaxDYyf8TN+c+On47C/nD5+TnETERFpiAmaiIhIQ0zQREREGmKCJiIi0hATtDEShG4dlUpFPeruUHznSMkQ9YoL3o5bc+o41V/dOz8ZuuL7y+PPo0jFvvL5orRCuFnc24/XferUmKANkQzbaPqyWMYCi0WMVtRF+9ytjU4uCUVybndflwoVSbvdjdCSxz+eoOY3WfiE8oXuq/NF1ZgGk9a+lx9wWj0mjvh+DTdnLmfFBG0IWS7N9h7QUA3Mwl3Lxix4MmhUbIIQg/4cvZ73qlRo8hRg5vTQkcffauBenG/8MTM0vS0c+6/OFyZbvR/Z83PJT9BiBFWpr6c1ZLnCCofcpdUYLTBVZ+cN++qbiqsut55N79RdDNflUUlLYuQ/HaFRzZ5uUAO02/ULst4tomcO0OhN2+eLBE/Bdvsxiyw3aaN1V3i2PIn8BN14gIcuBjInq+mxGiYj1o+9Dod0uLQeeNSK0yme6QNuxm9MnVIJJHiOsi8z1k0t+4ooX+jKAXoVQW2Cx90BviGSYR++3cIF8nPRFLeFzqOHqO/CHXRRmxxY6J+0F7pVMfTyijtc8oRg5qC3+jeWGLO9njolouslr6TlGnQPTYPWoDelFzNOr1M823gixWvQVge9mg8/cnDP7HwV5FJF03cwme5pcPGcV8tXw8LuBXOye0lNlCsbnPtj8z7BkV2oXCr/FSfoZIi+OJk7tQh97vgtPZmcq3KpYnHAbEj1llfLV0SuOc/m600Eck167x4EMlSCYb3CXf5COOhi5txfbPa4IEGna5Byans06qHWbZ/9M2D0/qySc3zgUoV1h5btbwzMkrSxZs+oXKy7lrgC6qd9OJGbXgCH02L0pnTGxe8vNwlnff+CieoyLt9PchO0/NxstzZBui+sgQcP6LZN+rD6NQkx6MrU6qNZXX7oXj6KbjqS7kGoBdVsF/cAz/dcg9aaukGJOFZVOZCaoauOdXaMrQ4evRoC+b1qE5Gz7NtErzVGMSa1AFV1nqiiDw+xaQ0mHMO3PTxcMGyWm9zA+Bk/4zc3fjoO+8vp4y9egyYiIqKLYIImIiLSEBM0ERGRhiovLy+rNWgiIiLSAzeJbWD8jJ/xmxs/HYf95fTxc4qbiIhIQ0zQREREGmKCJiIi0hATNBERkYaYoA0SuvXsFp8V1F3ettU0SeimtwKVj7qLkA2ACiTDdXupG1g5Q4f+wgRtCtHYmr4slpHWd21FXUPruxpKHP9qM0JLHf8F4laEJu+tT3mSIdrdrL3EE9T8plnVrTTpL0zQhgjHPmzvAQ1VX9DCXYtlL0ySHv9HdLL6klZnisW+muBkrOQpwMzppe3FauDeAfyxORlal/6Sk6DTeqD1zfqSqlJOUfUj0lljtMB02drE8X0KZrBvq9nzHOKYu6IdVCrp1DinxcsqwXMkyz8zHdNhZL3wzfODrCeO6NmQ/q9Pf8lJ0OkV1ix4Wh2QdERlWj3Q6xO6MuFWEdQmeFwl7LeIQdogAHpyikeMHrNp8QFHaCUUQ5xvgeflgCtdU2N9d3pbmqA2WbJAtDH06S+5U9xWpwdnFuBJ/VHpFRcLvJefvJKWybaH5p41aAud0XRVMzgR7UD20eiZZ/Wy8sV46/4xPf6TWsT67kQFdOgvBWvQct1hhkBlaDmicMD8fC0sNB482P64cMliuYuxLkaPg8EA/Z1RNZVFFXKG0ul1VnsQGg8t2LO56NlEuyw1GN+U7F5SXzV9+kvhJrHGvZNOc4dj+JzeLrF0T8FRuzDlLs6mnOFeYDodYTQaoWfSLNdVSU+4nP2gQ8k159l8nY7kmjRqN6IlmUCf/lKYoEWGVtPc7b7P6e1SSxuc319O0SQIB93j9hQkIcZ+9jWVjhpsdwfZOlp2/O1bca1A9Jp1J64Y/X7aXrK+b1IO0KW/FCfobJp7NrOxb8Mv6a0xkusoAapyw0Olij48xMsF5rdYHfScCE01xV1HfQDcOtlrVD6NEeIJEFTT49+MHEz4MSvKI/r/o1dL20u1iciZrPajGEGT/rK33GQyrKMatBAb0JlZPo3xM35z46fjsL+cPv49V9AhBt2ZWiznSJuIiOh88hN06IpLezm14eGBy89ERERnlZ+gGyPI2e/piFfPRERE51Z5eXlZrUETERGRHvZuEjMJ42f8jN/c+Ok47C+nj3/PJjEiIiK6BCZoIiIiDTFBExERaYgJmoiISENM0AYJ3Xpa21TevtPdVzothCv+3VEFNkgPyRD1Sn2nfm1y5PEn0yXDtJpd2l6u+ESgcX9hgjZF6KLp1zCJ0/qmrai7px40lVESipNNuwtZb35TMmy/Ov7t7TMS0ZqsZteN0JLtJZ6g5jevcrCue39hgjZEOPZhew+r+qZ3LVt9n65JiEF/jl7Pw+7RleUCd4+/KiWrXiXaljwFmDk9dGR7sWTRJMAfX1uG1r+/5CTotH5wfXPEoKYB3MIC/6SvxmiBqeptUoKnQDTAQ0qUPYdwRVtQUz11Hn+9NTCajtB447BuH/+MMfV96VgqQW2cH2R9aETPVzag07+/5CTo1yOGdER1RP1g0lLoymRbRVCb4HG3Ab7BD57xME2neSY1H01Oi1+BIwZoZKAEz1H2ZcaSBeWNdbn+kjvFbXV6cGYBnlSGTv9Akwp2Xys5MpTJtofmQWvQ60pmlipiDn/Mq+iSC90quvAOGqARme6S/aVgDVquO8wQqAwdYz5zwPx8LUSyffBgH5tsq7ev1mqoXGR996Z/meLzVBYWdi+Yk91LakNcur8UbhKTV0xqmjscw+f0domlewq+8ux0PH+125HKQ55sqt0aJosR+zIVkmvOs3mcPUvXpE3bs6BDfylM0CJDq2nudt/n9HappSNiv7/8LF+CcNA9aE9BNA7XPzP2IRoCT+4ltDrZxEzOtJ9114Lt99PPBich0q5vTsvRpr/IalZLsvTkromDBWAvvDj7xhV7K/7rEYtjacvKZephO574zrbt+CcLRx73ibdw7PRnYL/+mWtS+uMfews7O77rhyOOpDyWu99fvrZ23e2fjhV7zqo92c5mS0mxv5w+/r3lJtVIImghNmDNiuXTGD/jNzd+Og77y+njL57ilh/k7s42dvISERHROeQn6NBFpdJE5Hh44KIVERHRWeUn6MZIrk9jOuLVMxER0blV5EJ39jURERFpYu8mMZMwfsbP+M2Nn47D/nL6+PdsEiMiIqJLYIImIiLSEBM0ERGRhpigiYiINMQEbZDQraNSkfWgK6i7y/tykxkSDLeOP4uGUhG2l2Toon7h+JmgTRG6aPry5u9pPehW1D2oHjRdB1XTNmohXojjH09Q85uoq0oIRK8Z316SIdrdCC15vsziv8TpkgnaELISle09oKHuOmPhrsXKzubIqhEtb9lrNTCaZKVk1etEm9hekqcAM6eHjnwDRPz3DuCPz5+hcxJ0Wj94a8QkRhT1intcgX/SRmO0wFS1NinBUzCDfVvNnudIQriiHaTTXHW4vOK6HtVb2LM51hV/iQoY1l5k/evN86Osj43o+ewDlJwEnV5hbY6Y0hEFawGXXejKZFtFUJvgcZWw3yIGae0molasbvm6iHtAt3qRaR76qtZXAGl/zuqBI8Izx1z0iuntJcFzlH2ZsWRB/QvIneK2Oj04swBP6oCkV1wmFey+VvJKWq5B99AsXoNOnhDMHPSWSVxOc4lEPWITKKXGaAInEsdczobUB3i+92CjhpuiMRoZi+1FDwVr0HIUNUOgMnSMuThZMz9fCwuNB9Hh/HH+kkU8FyNmuh5igDWVgzPxmI7Q2bO6QaYzub1Y2L1gTnYvqc+kcJNY4z7bGBCO4XN6u8TSPQVHTU/LNafsS7o+asnKvgXzNB3CtPYi15xn8/WKu1yTRu0m3TR3RoUJWmRoNc3d7vuc3i61dETo95effc7WlIoGXdYdWraP/mpj2DskedLEzqbPJMSgO1vv0iXawvZi3bVg+32ot0DEr3a1XyAHFifobJp7NrOxb8Mv6a0xijGpBemaUqWKPjzEhQvKFjqPE9SCaraLO91YxjXoMto5ltU+4MU8lpSD7QVWB49eDUFVxt9E5Fzm3Le33GQyrKMatBBPr3/0xPJpjJ/xmxs/HYf95fTx77mC5lQYERHRJeQn6NBFpSIv7T08cCqMiIjorPITdGOktthPR7x6JiIiOrfKy8vLag2aiIiI9LB3k5hJGD/jZ/zmxk/HYX85ffx7NokRERHRJTBBExERaYgJmoiISENM0ERERBpigjZI6Naz23ZWUHeX9+U+QjJEveLmV8AijYVws2O/fPC+6lQkGbqivy/PF6Y1Fj36CxO0KUIXTb+GSZzWg25F3eJ60HSFHExk+cDswXtxUy4xGG93I7Tk+SKeoOY3DRzQXb6/MEEbIhz7sL0HNNRdZyzctVhM0ijJMyKWl6QDqfKSTg8deb6wZNEkwB8blKE16S85CXqn3JjE6c1Sa4wWmKreJiV4Cmaw95UoE8fcFe1ATfHUXQzX5VGplAIMVsfzHZY4yBiy/vHm+UHWR0b0bFibuXx/yUnQ6RXWLHha/VHpiKqgfjCVQujKBpeWjnxcJey3iEFau4uoFadTPNMH3Iy7mGWvUsnEc8xmNdw/yum6GB64xEF5EjxH2ZcZSxaUN4km/SV3itvq9ODMAjypDJ1ecV2iYDW9X/JKWja4HprFDS55QjBz0FslcQuNBw+cGC8pdW/90WqJo9NzDLwiIjqQJv2lYA1arjvMEKgMHWMuTtbMz9ciS7b+OH/JQo4gsy/pSs3momcT7bKwe8Gc7F5Sm+gC/aVwk1jj3kmnucMxfE5vl1i6p+CoGZrqLa+Wr0bO8eemMcoh15xn83U6kmvSqN2I1G0CffpLYYIWGVpNc7f7Pqe3Sy0dEfv95UaHBOGgW7ynwLpDy/bRX20UzH4me0Zlku4pkcc/VIdTnIBEn7Zbd4accOlY1l0Ltt+H6v5JiLEPg3KAPv2lOEFn09yzmY19G35Jb41RjEktQFV96L6KPjzEhR/ss9B59FALqtkuxgGe77kGXVZW51Ed/2b10E2CZDSrg0evhkC2l2oTkTMx6nPzuvSXveUmk2Ed1aCFeNq5+tE2y6cxfsZvbvx0HPaX08e/5wo6xKA7g9O7/uRMRESkk/wEHbri0l5ObXh44PIzERHRWeUnaPU5sAWmI149ExERnVvl5eVltQZNREREeti7ScwkjJ/xM35z46fjsL+cPv49m8SIiIjoEpigiYiINMQETUREpCEmaCIiIg0xQZsmGaJeqaf32CWjhG49vW2reNTdyxSgp/Iwvb0kQ1ecK5fxH1Np6P1hgjZIEork3GbBCyOFLpp+DZN4WQ/8MgXoqSRMby/iQqbdjdCS8ccT1PzmcdUA3xMmaGOEGPTn6PVY8MJEqp6vrF6m7jpkqVKylyhAT+VgentJngLMnB5UfQxLFo0C/PH5M3R+gla3+kwv75cPDrjLrIHRdITGMVXJxCjSrctjn051cVq0vCxVb3S8Kp8XjllukvKZ3l5k/Wt7o4SjrI99iQFKfoLObvWpHhMxfLB5T26zJBgOAqAn28BUTXO1oi4GHKSVk+jPEy9alc/rg+UmqYDR7SWBnEDYpAYsF3DAFHcItxnBe+Q9uc1ioTOarmrAJmLoKNto9Mxr6DKSZWObsmysGnTLNcUm16ApF9uLHvYm6NBtIvIe07l4MkoSprsY63UXg8EA/Z1RJZVFgqdgs2yshcaDB1tOYarnRJtMby+WuhjZpNbkL6A4QcudfJHHqTATyV2MTTnDvcB0OsJoNELvMrM8RERnJdecZ/M4e5auSaN2kw1Yzic/QcvPy3Jqm5aSEGM/+5pKJr0i8PvLTX4JwkEXM7lLVz0n2sT2Yt21YPv99H4R2bnPuT9/9LkJWm0zF//rqk0C6aPOu1uUl7pBiTiOVfk56OVxdfOnrKwOek6EpprirqM+AG6d7DUqncYoxqQWoKr6stz04yFebjAg2mF8exHnv0evhkCeJ6tNRM5ktR/nnFhucgPjZ/yM39z46TjsL6eP/4Bd3ERERHRuTNBEREQaYoImIiLSUOXl5WW1Bk1ERER64CaxDYyf8TN+c+On47C/nD5+TnETERFpiAmaiIhIQ0zQREREGmKCJiIi0hATtGnULT/r6T1mC4VwKxWwwtz1CN36+ra97vI+y0RvM729JMO0ml8a/2VOhEzQBklCkZzb8l7cZBxZmc6vYRIv6/t2Wd+X8pneXmQ1v26Elow/nqDmNy9yscIEbYwQg/4cvZ4HO/sOmUPVs5XViFRpOguNeweInnkVTW8yvb2oYlFOD6rSstWADN8fnz9D5ydoMYJaTm8sHxxwl1kDo+kIjWr29FDPIdx61gbqBdWvSGuWqh84RqjOsAnCsQ+7dcdSsvQm09uLrP9s365PlrI+9CUGKPkJujGCvIeJekzE8MH28MDqdMbxg2c8TNNprknNR5OjtHIS/XniRWiqMqOyfOAEj+rygOgNRreXBHICYZMasFzAAVPc4gqqGcF77HC0bSCntzzu2TSXHFWr51QmybCOZtBCrAbdck2xyTVoysX2ooe9CTp0m4i8x3QunsxWveX6dSkleApm24OtBw82B1v0JtPbi4XdC2a1Jn8BxQla7uSLPE6FUSqecwc4EV09ueY8m8fZs3RNGrWbbMByPvkJWn5ellPbxovGYbYxIt0oonZ2qudUHukVgd9ffpZVHMtBFzMeS3oT24t114Lt99P7RSQh0lPf+aPPTdBqm7n4X1dtEkgf9f13tyBdqRuUiONYlZ+DXh7XfbuybbTunzFQu7irajYlHvGUXkaNkdzkF6Cq+rLc9MNjSfmMby9WB49eDYE8T1abiJwJLhE+y01uYPyMn/GbGz8dh/3l9PEfsIubiIiIzo0JmoiISENM0ERERBqqvLy8rNagiYiISA/cJLaB8TN+xm9u/HQc9pfTx88pbiIiIg0xQRMREWmICZqIiEhDTNBEREQaYoI2jbrlZz29xywZIoSb3a53+8F2QG9he5GSoZveHlk86hcqtckEbZAkFMm5Le/FTWZpYKTq+m48Jo74fg03rIRDr7C9yAuZdjdCKxaxxxPU/CYukaOZoI0RYtCfo9fzWNOZVGUy23tgNSs6iGntRRWLcnpQlZatBu7F+MQfnz9D5yfo0N2Z3qhcZARB74sYFU9HaFSzp4dIQriqkpV81OFyPvRKyPJ5Nlp3vHymQ5jXXmT9Z/t2fbKU9aERPWflN88nP0E3RtvTG7aHBw63DZJg2G4iasVpG4h7QLfKQdoVSIZ9+HYLzM90CPPaS4LnKPsyY8kC2RdwwBS3uIpqRvAeO2B/NkjyhGDmoKfmeAQrXZdiCeGyS/AUzOD02J/pEGwvl7Q3QYeuuIryHtO5eDJHPOdmsmuUDbzuOdCiQxjZXizsXjAnu5fUZ1KcoEMXzcjDI7Ozeaq33Ex2hcJBFzPnnpvD6CCmthe55jybx9mzdE0atZuzzyLkJ2j5eVlObZvLukPL9tFfbQxLMKxzo2C5yc0+gMPLZzqIue3FumvB9vvp576Ty70PuQlabTMX/+tW17u469zFW17qBiXiOFbl56CXx9UVXTCPhc7jBLWgmh3/KoLahGvQZRaO4XOzJx3K5PZidfDo1RDI82S1ici5zLmP5SY3MH7Gz/jNjZ+Ow/5y+vgP2MVNRERE58YETUREpCEmaCIiIg1VXl5eVmvQREREpAduEtvA+Bk/4zc3fjoO+8vp4+cUNxERkYaYoImIiDTEBE1ERKQhJmgiIiINMUGbRt3ys57eY/ZY6meLbg9KWsg5xsnQTW/3Km/by5uq0xLby5t0iJ8J2iBJKDpiW96Lm65V7jEWJ+F2N0IrXmART1Dzmyx8QmwveTSJnwnaGCEG/Tl6PY9lJK9W/jFWxW+cXlrX3Wrg3gH8MTO02dhe8ugSf36CDt2sitH6wRF3mTUwmo7QqGZPDyFGkW49O/51F8N1eVTSUv4xlvVs7dv1C7LeLaJnsD6dydhe8ugSf36Cbowg72GiHhMxfGCZOsMkGLa7iFpx2gamD7gZc3q8nBI8R9mXGeumln1FtMv09qJP/AdMcYdwmxG8xw7k1T4ZInlCMHPQU3M8koXGA6fHiYjOZW+CDt0mIu8xnYsnc8RzXi1fDQu7FwDJ7iUC0Yrp7UWf+IsTdOiiGXl4ZHY2T/WWV8tXRK6hzebrTQRyjQ21G86K0ZtMby+6xJ+foOVn4zi1bS7rDi3bR3/14cgE4YBr0GVl3bVg+/30s65JiLEPOPfcVEJvM729aBO/rGa1JEtPLsWeLatcbT1sL85evU6b8V+d2FuIK+KdY+osJtnL0qv4xc84dvZvbWfhTeTv2P6Za1L647/nGMees3rddl4fxatu//Qa20shHeJnuckNjJ/xM35z46fjsL+cPv4DdnETERHRuTFBExERaYgJmoiISEMVudCdfU1ERESa4CaxDYyf8TN+c+On47C/nD5+TnETERFpiAmaiIhIQ0zQREREGmKCJiIi0hATNBERkYaYoImIiDTEBE1ERKQhJmgiIiLtAP8fyt3jZAa+F/oAAAAASUVORK5CYII=)
I cell H2 kan du peta in lite bygggstenar.
1). Hämta saldot för varan i F2:
=SUMMA.OM(A:A;F2;B:B)
2). Räkna hur många som redan önskats av högre prioriterade kunder (prioriteringsnummer i kolumn E, 1 = högst prioriterad)
=SUMMA.OMF(G:G;F:F;F2;E:E;"<"&E2)
3). Räkna hur många varor som återstår till den aktuella kunden
=SUMMA.OM(A:A;F2;B:B)-SUMMA.OMF(G:G;F:F;F2;E:E;"<"&E2)
4). Gör att du inte kan få minusvärden i H-kolumnen (max 0)
=MAX(0;SUMMA.OM(A:A;F2;B:B)-SUMMA.OMF(G:G;F:F;F2;E:E;"<"&E2))
5). Räkna ut hur många varor kunden får (antingen det önskade värdet i G2 eller så många som var över när högre priorigerade kunder fått sitt):
=MIN(G2;MAX(0;SUMMA.OM(A:A;F2;B:B)-SUMMA.OMF(G:G;F:F;F2;E:E;"<"&E2)))
6). Kolla hur många som blir restnoterade i kolumn I
=G2-H2
Kopiera ner formelerna i H2 och I2 till alla rader.
Och dubbelkolla att det blev rätt. Jag körde bara lite slumptal.