MS Excel. Приемы работы с данными. Юрий Николаевич Лубягин

Чтение книги онлайн.

Читать онлайн книгу MS Excel. Приемы работы с данными - Юрий Николаевич Лубягин страница 5

MS Excel. Приемы работы с данными - Юрий Николаевич Лубягин

Скачать книгу

target="_blank" rel="nofollow" href="#_5.jpg"/>

      (В примере диапазону ячеек массива присвоим имя «ПРИМЕР». В дальнейшем диапазонам рекомендую присваивать осмысленные имена.

      Полезно знать. Присвоить имя можно и одной ячейке. Удобно это будет когда, используется функция «СЦЕПИТЬ

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAZABkAAD/4gHbSUNDX1BST0ZJTEUAAQEAAAHLAAAAAAJAAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLVF0BQ4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlyWFlaAAAA8AAAABRnWFlaAAABBAAAABRiWFlaAAABGAAAABR3dHB0AAABLAAAABRjcHJ0AAABQAAAAAxyVFJDAAABTAAAACBnVFJDAAABTAAAACBiVFJDAAABTAAAACBkZXNjAAABbAAAAF9YWVogAAAAAAAAb58AADj0AAADkVhZWiAAAAAAAABilgAAt4cAABjcWFlaIAAAAAAAACShAAAPhQAAttNYWVogAAAAAAAA808AAQAAAAEWwnRleHQAAAAATi9BAHBhcmEAAAAAAAMAAAACZmYAAPKnAAANWQAAE9AAAApbZGVzYwAAAAAAAAAFc1JHQgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAEbAfIDASIAAhEBAxEB/8QAGwABAAEFAQAAAAAAAAAAAAAAAAUBAwQGBwL/xABVEAABAwICBAkIBgUMAAMIAwABAAIDBBEFEgYUIZQTFTFRVZHR0tMiQVNUdJKTsxcyNlJj4RYjNGF1JCYzNUJFcXKBsbLiJzdEQ2Jlc6Giw/BkgqP/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/xAAsEQEAAQIEBQQBBQEBAAAAAAAAAQJRAxESIhMhMUHwMmGR0QQUQnGBocHh/9oADAMBAAIRAxEAPwDa8A0fpcSoYcXxeBlZPVt4WOOYZ44o3bWgMOwnKQSSCbkgbFMfo3gXQeGbnH3VXRsfzXwj2CD5bVGxYniRxsYA6d2ssqjO6bg2jNSfWHmt9YiPzHYTy7V2jKMocpz6pL9GsC6Dwzc4+6n6NYF0Hhm5x91WKfSqlqZK9rKOqa2iZI8ve6JrZQx7mOLSX7PKYfrZVapdM8OrcGnxKngnlENSymMMb4nudI4tDQ1zXlhvnG3Nz8yRMT5/RlOeTL/RrAug8M3OPuqn6N4H0Hhm5R91Y0mmeGw4ZJXywVTWx0zKjgsjXPdnc5oYACbuuw/u89+W1Z9K46epqopMIxAMpaU1ckwMOTgrOII/WZtuQi1r35bDamqldNTI/RvA+g8M3OPup+jeB9B4ZucfdWXh2KYfi9Pw+HVlPVRg2c6GVrw02vY2JsdvIoyTS2kjrqylNDWHVIpZTK1rC2QRlofl8rNcZxygXsbXVzjPJnKWR+jeB9B4ZucfdT9G8D6Dwzco+6sDG9Jp4Z4qHCKaSoqJpmx8I2NsjReN0mwF7bnKG/WIAzg7doVxukcNBgkM8seIVs5mdTuieyJs/CNDnODgC1mwNJuDYi1r3SaojqZT2Zf6N4H0Hhm5R91P0bwPoPDNzj7qsTaW4dBSid8dQc0kUbY2sBc4yNDhYX5AHXJ81irsGkdJV1s1HSwTzzU0j2ThmW0OXzuJcAM3mHKeWwFyGqnPJOcxmr+jeB9B4ZuUfdXk6OYGP7jwzco+6o+HTygqaCqq6agq6htI5rZmwS08haHDY7M2UtI81gb/ALlIRaSYc/EThtTI2hrsrHCmqZYxI7MCQGgOOYi2210zpP7U/R7Ax/ceGblH3VQ4BgfQmGblF3VlYfXRYphtPXwNe2KojEjA8AOAPPa6uOXSIiezM5wwOIcD6Ewzcou6qcQ4H0Jhm5Rd1ZtyqEremLMapuwjgWCdCYZuUXdVOIsE6Ewzcou6szaqG6aYsmqbsI4HgvQuGblF3VbOC4MP7lwzcou6pAq24FXTFjVN2HxLg3QuGblF3U4mwbobDdyi7qy7FU2pppsmqbsPibB+hsN3KLupxNg/Q2G7lF3Vlqm1XTTY1TdicT4P0Nhu5Rd1OJ8I6Gw3cou6stUsU002NU3YnE+EdDYbuUXdXk4RhHQ2G7lF3VmbV5IKaabGqbsYYRhHQ2G7lF3U4owjobDdyi7qyrFNqaabGqbsXijCOhsN3KLuqnFGEdD4buUXdWXYqlimmmxqm7F4owjofDdyi7qrxRhHQ2G7lF3Vkommmy6pusDCMH6Gw3cou6vQwbBuhcM3KLuq7tVQ43U0xY1Td5bgmCn+5cM3KLur2MDwToTDNyi7quscrgKaYsapuxuIsE6Ewzcou6q8RYJ0Jhm5Rd1Ze1NqmmLGqbsXiHA+hMM3KLupxDgfQmGblF3Vl3KrdNMWXVN2JxDgfQmGblF3VTiHA+hMM3KLurNuU2qaYsuqWIMAwPoPDNyj7qr+j+BdB4ZuUfdWYLqt1NMWXVLD/R/Aug8M3KPup+j+BdB4ZucfdWaFVTTFjOWD+j2BdB4ZucfdWLi2AYIzBq97MFw5j20srmubSRgghhIINlMrExf+o8Q9kl/4FSYjJYmc1To/o8CRxHhm5x9ij5cNwY1MkVPo9gQZHI2HhKpkcIfK5ocGNAjcSbEc3LsvtVyWqqBK+z9mY+YKHxKobTYhHXPhpXzRwyOYZrNzPGXLyC73DbZv+twQFzmnk6xPNOUeEaPVdM2U6P4bE7M5j43UkRLHNcWuFwLGxB2qOxDDMEpcRlDMHw0N4GI2NHEQCXS32Zf3DqV2ldUU0Aj4UvJc57nFo8pziXOP+pJUFpHVVgq3mN+3gYL7B96ZcsbbTm9H41MV4mmUiKbB+iML3GLurzNFgsERkdg2GEAgfsUA5TblIAHLyk2C1llZiPpP/tHYrhq8QLbOkFjsJcy4APnIAJt/gF4ONOeT7X6SiKZnk2V1DSMmlhdorStlgZwkofRUzWsZ94vPk25eQ/2XcxXmODBZYmStwfDQHtDgDQRA7f8A+qxanFKWfA2YIysqxHTNa6KpkicWSuBJyOYASGC4ts2WH3ReF1zES0HORccmUdi64tejLKXm/FweLnriI/psppsHH90YXuMXdVKXR3CMSjri2lipJW1IEU9KwROj/UxHZlsCLknKbjadi1Z9ZiXpP/tHYtv0PfLJQVrpTd+ti+y3/p4V0/Hr11ZS4/m4MYVGcNGqdL6zDqmWhqmfr6Z5ilynZmabG37rhFr+lP2txj2+f5jkXfJ87N3TRs/zXwj2CD5bV5dhEsLMRqqWskkxOqhMcVRUZbRWuWNAa0ANDnE8hJ85OxWsEnZTaI4bPISGRYbC91hc2EQJ/wBlma5VdE1vvQ+IuvLLmxEznyQkOhPAuZC/FquopTS8BI2XgszSHB7HNyxi5DsxOa977QdqkKPRiCmqDPPiNbWufU608VBjs+QNa1pIYxv1Q0WHJfbtIFsvXKroqt96HxE1yq6Krfeh8RSNMG5gN0OwtsrZXPqHuZRmkZmeLNac3lgWtns9wvzE85vlVOA0lVreeSYa3RCiflcNjBm2jZ9byz+7k2K7rdV0VW+9D4iprdV0VW+9D4imVPnnvK6q88/O31C3h2C8WNqpY66oqqqoa1vDVOS4DQQ0WY1osLnzX2qHpNGKzB5KOvbXVWJSwRSsqKZ3AgSCTynhhyMuTIGm7ncgKndbquiq33ofETW6roqt96HxFdt2cpsisK0VjptHqOjknmp6uCU1DaiF4c+KQgiwLgQ4BhybQdgH7llRaM0bLcJUVM5AkN5XNJMjwQ6XY0eWQS3mA2ABZWt1XRVb70PiKmtVXRVb70PiJOmepuYbNFMNjlmlzzufLDHDdzwcjWBv1RawJytufPYcy8yaI4Y+Wrka+eM13CCrEbg3WGv/ALL9m0DzHlG0XsSDnazVdFVnvQ+IqazV9FVnvQ+IrlRnnmkaojKGHHoxA2GujqMRrat1c2NkkkpjBa1n1Q0MY0Dl5krtHKeuxJ1ZJW1bWPfFJJTMMfBvdEbsJJbmFjzOCzNYq+i6z3ofEXkzVZ/uus96HxFdmeeaZTZ6w+jhwvDaeggc90VPGI2F5BcQOe1lccVY4Wr6LrOuHxFTPVdF1nXD4i3FVMd2Zpqnsu3VLq1nqui6z3ofETNVdF1nXD4i1xKLs6KrLt1RW81V0XWdcPiJmqui6zrh8RXiUXTh1WeyvJVM1V0XWdcPiLz/ACroys64fETiUXOHVZ6sqEJ/Kui6zrh8RUOtdGVnXD4icSi5w6rFlSyZavoys64fEVMtX0ZWdcPiJxKLnDqsWSyZKvoys64fEVMlX0ZWdcPiJxKLrw6rBC8HlXvg6voys64fEVOCq+javrh8ROJRc4dVgJZODq+javrh8RODq+jazrh8ROJRc4dVlEsq8FV9G1fXD4icFV9G1fXD4icSi5w6rPNksvXBVfRtX1w+IqcFV9G1fXD4icSi5w6rPKp5174Gr6Nq+uHxFTgKvo2r64fETiUXOHVZ6a5XWuVkQ1Y/u2r64fEXoR1Y/u2s64fETiU3NFVmQCvYWMNbH92VnXD4i9h1X0XWdcPiKcSm5oqsvKqs56rous64fETPVdF1nvQ+InEpuaKrLypdWs9V0XWdcPiKmaq6LrOuHxE103XRVZkgqqxxJVD+66z3ofEVeFqui6z3ofEU103NFVmRdVBWNw1V0VWe9D4irw1V0VWe9D4imum66arMlUkYyWJ8UjczHtLXA+cEWKscPVdFVvvQ+ImsVPRVb70PiKaqbrpqY4w2qjaGMrYXtaLB09MXPP8AiWyNB6k1Cs9bo9zf4qyNYqeiq33ofETWKnoqt96HxFnOm7WVVljUK31uj3N/irCq9HauqqHTOr6QZmMYWmieQMpcR/7b/wB8/wD0UrrNT0TW+9D4iazU9E1vvQ+IpVoqjKZapqronOlCjRWoH/rqLcX+Mq/ozUj/ANbR7i/xlM6zU9FVvvQ+Ims1PRNb70PiLlwsGzt+p/Iuhv0aqPXaPcX+MvJ0bqPXaPcX+MprWKnoqt96HxFThqnoqs96HxE4ODZf1P5F0IdGJyf22j3F/jKWw+hjw+nMTHF7nvMkjyAMzrAcg5AAAAOYDl5Vc4Wq6KrPeh8RIphNnBjkifG/I9klrtNg7zEjkcPOulFGHTO1yxMXFrjdLhelP2txj2+f5jkTSn7W4x7fP8xyLI7LSD/w/g/gzfkBbKtapP8Ay/g/gzfkBTOLURxLCKuhbII3VELow8i4aSLXslfSCjrLMRanK3GarH4I6wxYZK3D5jHNQVAncbPivskiAHUeXzLEkxWtpcHwmSv0lmo46yldUSV0sUAPC5WFsQJZkAN3G1sxy7DsXPtn53+m45zk22oxKgpaqGlqa6nhqKg2hikla18n+UE3P+iyloFJiGIRYg6smrRT4rVyUxfhZZH+siMbMztreEswmQ7DYFpuOW97C9Mq3EKCij4Shkndqxlmo6oTkZpGNc2RuQCNzg42AvyO5lYjsmfdvKKB0hrcSoqmCOje7LXtNNFZgdwMxILX8nIG5yb7PIHPtiY9J2y6XNpo8fhfEKx1KKFr4SXBsJJcRlz34QW5bbLWUjms+eedG6IudQ6XV7hXujxRkjZqN8lKzh4ZZYJc7WsY5rYmhr/LAyEvNxy88jFi+M02NVGEtrZa2QCZsL54WeSQ2Ahz8jWizeEfs2X2Dlsnnwd8m6ItRw+bFqmpwqWTHKvJU4brcsIigDC9oj2f0eYA5iTtvzEK5ojpVNjTaemn1KeU0glkno6sTZXeSCJWhjRG43uBt5HcyuXPLzv9J2zbUi0moxHG6ambiMOJVFU+WorI20boYjH+rExYAGsDztY3+1tWBWaS1zAyOh0nhqKN08bTiU01PC3MY5HOiL+CcwWysP1CfKsSo1k6Ki0yjnxeupsFmOP1setzyQycHFTlsjWiRwe0mLaDlbZwsHNscousTEdJcSp31roMWBq4zVCWgMcdqONjXGOW1s23Kza4lp4TYORMueSQ35Foc+kFcwTMw7HJMVpXSQNZUUzad8xe4vzxRWaI3OADHEEEhpcSeS1mn0gx97eDqK40tIx7G1VbOIuGpW8NM25DWGO5yNaXHyW8tje4DoSLQKnS+aggqs+OQPp209TqNbKYhrTmiItIIAa4gue3yRY5eRZrNLtYr8uH10OIMOJcAyOmcx+Zppi5ouL2GcHyvNY7bBXIbki51LpFpA2WKGbGMOo3tEhbLVTspo6h4mkaW2dE/MAGs2Nc11jtJuCJCsx+aKnxOY6QNhxGFz2twsGEFjQ8BpY1zc7nubYtuS0ueNltii5c8m6otc0fxCqlwvE3YnV1VOKaZzRLXCBksLODY67sg4PZmJ5P8VEYTj+PVFQIaSopcVDWTkySVLWxuDeCsWSxw2ktnI+o3bcG+W5Ty+M0jm3pFz2PSnEpazDA3EWNe8UsdRTSzRB0pkDc0jIhEXFvl/WztFwdmzblYnpBpFQwRwSU0lNPHR3nnmMXBvcJImulaWZy1oDnuu5gAvctNiFchvCLSMMxvSCWaKKnrMKxcGKdxeyvDm2aY7ZpI4AC4FztgaBYi9yreH6S4zV0ETuHF2VdI2omfEAMkjIbsbsAuS9xJ8w5riyIz898hvaLScB0hrn4g+oxKrqjRClqJ3ySMh1d3BvaM0JYM5ZYmxdyi1rqQ0vxapo6HDpaLEosPbU1GV008rIG5eDc4AukjeG7QP7N/NsU7ZnfJsyLn9BppX0jwyrqKOrvA17Wz1TYZZzwkrbwtbHaa4a2xGUO8k2GZUxfS2aGm4M6QRUFREyslILoWvkLJSyJmV7TcEB3JYnLyq5DoKLS6jHsSOlmrtxbDqWmbLEI4KirZGamJzWkua0xFzySXAFsgF2gEbDfFdpBilMaWvdidRPTVsjnti4CNwEetRsZkyszHMx/nJvcEKRzy9xvyLTZqrHZ4amSTFp6KWLE4qcRU8cJa2OTgvJJex1y3Odt9p81rAeZsXxeLS0Ye7F6KCOGWKNkFXUsifVMLW5nhnA3e4kuALHtFwBbYbo55eW+y7dEWpaT41V4fiMkcWJ6m+OmZJR02Rh1+UuIMd3Ak8jRZlnDPe/IscaUCbSvgIsfg4PW3UwoWyQm4bASXEWz34QW5bbORTPlmuTdUWhDSXH5oMJqIHsy1VLCWslYI+HeZYWucTlJa053AWb+/bcWln4xiseAaQ1VWYoKmhc/gxC7hWxgRMcLEsbm2kna3z2Wsv8Av+J3ybOi02rxrFZK6alFU6jNVJSNo42Rs4VjHv

Скачать книгу