Excel sort dynamic data with duplicatesงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
...real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is developed with necessary security measures in place. This is to secure the ...
I'm in need of a talented Indian voice over artist to bring my promotional video to life. Key Requirements: - Language: English - Tone: Energetic and Upbeat The voice should be engaging, enthusiastic, and capable of capturing the audience's attention. Ideal Skills and Experience: - Previous experience in radio voice ...- Language: English - Tone: Energetic and Upbeat The voice should be engaging, enthusiastic, and capable of capturing the audience's attention. Ideal Skills and Experience: - Previous experience in radio voice overs - Strong understanding of the Young Adult demographic - Ability to deliver high-energy performances - Proven track record of delivering high-quality work on time If you have a dynamic voice and can meet the requirements, I look for...
...enrich content to offer a more dynamic and appealing user experience. Key Tasks: - Customize website templates in line with our brand image. - Create dynamic web pages that offer a smooth and interactive user experience. Content Addition: - The revamped website will include an array of content types for the most meaningful interaction. This includes blog articles for knowledge sharing, product listings for sales purposes, a portfolio showcase to display our achievements, and Learner Management System (LMS) integration for imparting e-learning. Ideal Skills: - Proficiency in - Experience working with dynamic web pages - Expertise in customizing templates - Familiarity with blog incorporation, product listings, portfolio, and LMS integration...
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to inclu...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 10-15 minute time. Regards, Kashish Bhasin
I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.
I seek a professional, ex...consideration the preferences of the target audience - Seamlessly integrate UX elements into the UI design to create a cohesive and captivating final product Ideal skills: - Extensive experience in UI/UX - A portfolio showcasing designed websites, ideally with a focus on young adult audience - A keen eye for aesthetics - Proficiency in design software - Strong problem-solving skills By understanding the needs of the demographic, you'll be tasked with delivering a polished, engaging, and user-friendly site that resonates well with our target audience. Let's shape digital experiences together. Please must attach work sample also we will need Figma files . NOTE: Please don't Bid if you can't reply instantly and have...
I'm looking for a dynamic, creative motion graphics designer to help create educational content aimed at making science more engaging and understandable to everyone. Key Requirements: - Experience in creating educational motion graphics, ideally in the field of science. - Ability to translate complex scientific concepts into clear, concise and engaging visuals. - Considerable understanding of designing content for a wide range of audience, especially those without a science background. Your innovative approach to design and ability to engage varied audiences is key to the success of this project.
...competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are similar so won't be issues ...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency a...
I need seasoned mobile app developers to construct a cross-platform social networking application, compatible with either iOS or Android or both. Key functional requirements include: - News Feed: Showcasing updates from the users' network in real time, ensuring interactive connectivity. - Private Messaging: Ensuring secure conversations between users. - Profile Customization: Allowing users to modify their profiles reflecting different characteristics and interests. - Request Management: Facilitators for creating, sending, receiving, and responding to requests for activities to ensure accurate matches and dynamic user interaction. The ideal developers should have comprehensive knowledge and proven experience in native languages for either or both platforms. Experien...
I’m looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure you...
...Specializing in the Meat Industry in UAE Location: Remote, UAE Job Type: Freelance with a potential for full-time engagement Description: We are seeking an experienced Sales Representative with expertise in the Meat Industry, specifically within the UAE market. Your role will involve intensive market research and lead generation, focusing on the importation and distribution of chilled lamb from Australia, Kenya, and South Africa. Responsibilities: Conduct thorough market research to identify and analyze the prices and competitors within the UAE meat market. Identify and reach out to at least 40 potential suppliers, including wholesalers and importers, to obtain competitive quotes on chilled lamb varieties. Essential data points include: - Lamb Price per ton -...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
As an innovative company, we are looking for a proficient Android developer to create a user-friendly app for both our property owners and customers. Key Features: - Property Search: The app should provide an effective way for customers to search for properties based on various criteria. - Communication: A built-in feature to e...Wishlist: A functionality that allows customers to save their preferred properties for easy access. Ideal Candidate: - Expertise in Android app development. - An understanding of the real estate industry or has developed similar applications will be a plus. - Excellent UI/UX design skills to ensure customer-friendly navigation. In summary, we need an app that seamlessly connects property owners with potential customers, enhancing user experience on ...
...Beginners, intermediates or advanced pros. - Ability to communicate effectively in English. Proficiency in Spanish (at least A2 level) is a plus but not required. - Strong communication skills and the drive to succeed in a remote, commission-based role. - Strong sales skills with a passion for connecting with clients. How to Apply: If you're motivated to join a dynamic team and contribute to the success of businesses online, we'd love to hear from you. Please send us an email moorazulbusiness with: - Your current availability and timezone. - Nationality and Country of Residence. - Your experience level. - A brief introduction about why you're interested in selling our services. - Your resume/CV/Portfolio. - Phone Number. - Inst...
...are seeking a skilled freelancer to customize our school SaaS ERP control panel by integrating WhatsApp and inbox SMS APIs. The goal is to create a dynamic frontend and backend system that allows seamless communication between the school, students, and parents. The ideal candidate will have expertise in Laravel, MySQL, and Firebase technologies. Responsibilities: Customize the school SaaS ERP control panel to integrate WhatsApp and inbox SMS APIs. Develop a dynamic frontend interface for easy navigation and user interaction. Implement backend functionalities to manage message sending, delivery, and history tracking. Ensure smooth integration with existing databases and systems. Create a secure authentication system for users accessing the platform. Test the system...
...are seeking a skilled freelancer to customize our school SaaS ERP control panel by integrating WhatsApp and inbox SMS APIs. The goal is to create a dynamic frontend and backend system that allows seamless communication between the school, students, and parents. The ideal candidate will have expertise in Laravel, MySQL, and Firebase technologies. Responsibilities: Customize the school SaaS ERP control panel to integrate WhatsApp and inbox SMS APIs. Develop a dynamic frontend interface for easy navigation and user interaction. Implement backend functionalities to manage message sending, delivery, and history tracking. Ensure smooth integration with existing databases and systems. Create a secure authentication system for users accessing the platform. Test the system...
I'm seeking a talented Blender artist to create an engaging and eye-catching cartoonish animation for an upcoming advertising campaign. Key Responsibilities: - Develop a high-quality, detailed, and dynamic cartoonish animation in Blender that is suitable for advertising purposes. - Implement creative and innovative ideas to ensure the animation is visually appealing and captures the target audience's attention. You should be well-versed in: - 3D modeling and animation using Blender. - Creating animations with a cartoonish style. - Understanding the requirements of advertising and how to tailor animations accordingly.
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to u...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm seeking a seasoned marketing professional (with a minimum of 10 years of experience) to manage the dynamic marketing landscape and sales performance in our label manufacturing industry. Key Responsibilities: - Develop comprehensive marketing strategies to establish and expand our reach in the B2B marketplace. - Manage various advertising campaigns, ensuring they align with our overall marketing strategies. - Conduct extensive market research to gain a deep understanding of market trends and customer behavior. - Forecast market trends accurately to be ahead of the curve and adjust marketing strategies accordingly to dominate the market. Financial Objectives: - Increase sales revenue by implementing process improvements and innovative strategies. - Reduce ma...
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
I'm in need of a talented graphic design...for my Instagram posts. These graphics should be eye-catching, yet in line with a vibrant and colorful theme. - Reels Creation: Additionally, the job will also involve creating engaging reels. The reels should be dynamic, promoting audience engagement and interaction. It's important that you have a good understanding of social media trends and what performs well on Instagram. Your work should be of high quality and aligned with the theme I have in mind. Ideal skills & experience: - Proven experience in social media graphic design - Proficiency in using design software such as Adobe Illustrator, Photoshop, or Canva - Understanding of Instagram trends and reels creation - Ability to create content that resona...
I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as Excel)
I require a highly experienced photo editor to transform my son's basketball picture into a dynamic and stunning trading card image. Key steps include: - Removing the background from the original photo - Enhancing the color for a vibrant finish - Retouching the skin for a professional look - Superimposing the edited photo in the center of a high-resolution JPEG trading card image Your expertise in Photoshop or equivalent photo editing software will be crucial for this project. A keen eye for detail, maintenance of high resolution and an understanding of visual balance are required. The task needs to be completed quickly without compromising quality. Bring your creativity and get this project slam-dunked!
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
