The Excel 2003. Create a functional document.
Make in a book on any paper three falling linked lists.Each of them must contain data without duplicates, respectively, 1, 2 and 3 columns.When selecting the value in 1 list - in the second, the data of the second column are displayed only those lines containing the value in 1 list in the first column.The third list is accordingly.That is, it has to contain the meaning of only those lines that have the appropriate chart in the first list - the first column and the second list - the second column.When the data is updated in the table, the data in the lists must be updated automatically, or manually (with a short action).Restrictions: Without using VBA, only features that are available in Excel version 2003.
Client's review of cooperation with Petro Shpak
The Excel 2003. Create a functional document.The work is done. and quickly. But the methods of implementation are unoptimal. Strictly according to TZ.
Freelancer's review of cooperation with Ivan Bezdomny
The Excel 2003. Create a functional document.I was pleased to cooperate.
and thank you.
-
412 7 0 Good day . Experience in working with Excel. Interesting task is to understand how to do this using the formula. Go back, I’m glad to help.
-
250 2 0 Good day ! Your task looks interesting. Let’s discuss details in personal messages.
-
419 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
3668 107 0 Why do you stop using VBA?
This is a more reliable function and formula.
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 1 day 8 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 2 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 19 hours back ∙ 88 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 2 days 22 hours back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 4 days 20 hours back ∙ 6 proposals |