Excel consolidate multiple columnsงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ 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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
...grasp of information organization and UI/UX design principles. The end product should be user-friendly, visually appealing and fully functional with the capacity to capture all the necessary details. Implement an online CV The site will consists of 2 parts: user area As a user I can view the CV and also be able to download it. admin area This page is protected by a login From here I can add multiple languages and add translation for each language From here I can also change the text that is displayed on the page Structure for page (minimum requirements): Page: header biography portfolio contact form footer At least 3 different animations are used The user can change the theme: dark vs light The user can change the language: at least en and ro It will be responsive at lea...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
Description We are seeking an experienced and creative jewelry artist/designer to collaborate with us on creating unique tungsten ring designs for our business. The ideal candidate will have expertise in CAD software, a strong understanding of materials and manufac...SolidWorks) and other design tools. *Strong knowledge of materials, and manufacturing techniques relevant to jewelry production. *Creative flair and ability to translate conceptual ideas into tangible design concepts. *Good communication in English, and ability to work collaboratively in a remote way. Additional Information: * This is a freelance position with the potential for ongoing collaboration on multiple design projects. *Remote candidates are welcome . Budget: *Budget is negotiable based on experience and proj...
I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
...suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Knowledge of cybersecurity measures - Experience in dealing with compromised online accounts - Network security proficiency The project will entail: - setting up a closed in-home network in my home in Re...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
My Server that I access via remote desktop services has stopp...allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is available. REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at that server terminal to give you acce...
I'm looking for a talented...branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience in creating visual content for multiple platforms would be a big plus. Looking forward to seeing your portfolios and offers. Tasks Include : - Logo for the brand - Facebook - Cover + Profile Pic - Insta - Profile Pic - Twitter - Cover + Profile Pic - LinkedIn - Cover + Profile Pic All of the covers & profile pics will have some minor adjustments according to the platform, graphic...
Logo needed for brand offeri...the eye toward the center of the icon are preferred. > The core design should be in vector format, with .ai (CS3 compatible) and .eps formats required. Other formats are welcome and appreciated. > Fonts used should be identified and either commonly and freely available or be included with the design files. >>> Submissions should be made as soon as possible, <<< as they need to be reviewed by multiple parties before a decision is made. Early submissions will have a greater chance of being reviewed and selected. > Award of the contest prize will convey all ownership rights to buyer. All files used to create the entry should be delivered when prize is awarded. If you have any questions, please ask. We appreciate your help!...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should ...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...
I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love to hear from you.
...predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a minimum of 10 representatives. - Provide the capability to handle "N&...
I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to...
I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understandi...
I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.
We are looking for a developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L vi...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I am seeking a creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can
I need an email validator that validates multiple emails, preferably done in C#. As stated above, I need a system that validates whether the email exists or not. The system must be practical and easy and must have a license management system, which I can generate. I want only people who pay some plan for the system to be able to use the software.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I am seeking an experienced digital marketing professional who can effectively handle multiple areas of digital marketing. This includes: - SEO: Enhancing the visibility and ranking of my website on search engines. - SEM: Implementing strategies that increase the reach and visibility of my ads. - Social Media Marketing: Creating engaging and shareable content for various social media platforms to build strong relations with the audience and increase followers. - Blogging: Producing high-quality blog posts to engage readers and increase site traffic. - Web Editing: Tweaking and enhancing the website for a more user-friendly experience and better SEO performance. - Email Marketing: Developing and managing effective email marketing strategies to boost customer engag...
...3D designer to create a highly detailed and customizable 3D model of a chair for our e-commerce website. The model should allow users to configure various elements such as textures, chair legs, and other features in real-time on our site. Requirements: Model Specifications: A highly detailed 3D model of a chair. Different textures and materials for customization (e.g., fabric, leather, wood). Multiple chair leg options (e.g., wooden, metal, various designs). UV unwrapped and properly textured for high-quality rendering. Technical Requirements: Formats: FBX, OBJ, and any other formats compatible with web-based 3D viewers. PBR Texturing: BaseColor, Normal, Roughness, and Metalness maps. Optimization for real-time rendering (low-poly options if necessary). Ensure compatibility wit...
I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.
I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.
