Excel convert multiple columns to single columnงาน
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 )
I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibili...
I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. ...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
...Information including Phone number, Email address, and Home address. Requirements: - Extensive experience with Angular - Proficient in Front-end development - Attention to detail for aesthetically pleasing platform - Excellent 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 pa...
...talented developer to help us convert an existing HTML/CSS/JS project into Builder.IO. If you're experienced with and have a knack for turning static projects into dynamic, user-friendly websites, we want to hear from you! You'll be taking our current HTML/CSS/JS project and transforming it into a custom website, ensuring it's responsive and looks fantastic on all devices. You'll also collaborate with our design and content team to create a seamless and visually appealing experience. We're looking for someone with proven experience in , strong skills in HTML, CSS, and JavaScript, and a passion for creating beautiful, functional websites. pls answer my questions on your proposal. Do you have experience translating HTML/CSS/JS proje...
I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad ...
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 effici...
I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask ...
...an experienced social media marketer who can create an Instagram ad that will direct users to my Telegram channel. Key Points: - The primary goal of the ad is to promote my latest product, Medical Gummies, so it's essential that the ad is engaging and attracts potential customers. - The link in the ad should seamlessly lead users to my Telegram channel, where they can learn more about the product and potentially make a purchase. - It's important that the ad is set up in a way that maximizes conversions and ensures that users are actually redirected to my Telegram channel. Please only apply if you have experience in creating effective Instagram ads and have a strong understanding of how to convert social media followers into customer...
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 manufacturing processes, and a passion for creating innovative and visually appealing jewelry designs. Responsibilities: * Develop an original design for tungsten rings that align with our brand aesthetic and target market preferences. *Create detailed 3D models and technical drawings using CAD software. *Provide regular updates on the design progress and incorporate feedback to refine and finalize designs. Requirements: *Proven experience as a jewelry designer, with a portfolio showcasing previous work in ring design. *...
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 visu...
...of an expert who can convert B2B leads effectively. The goal of this project is to boost our conversion rates for our B2B leads. Some key elements of the project include: - No specific method: I'm open to you using whatever approach you feel is most effective. Whether it's email marketing, telemarketing, or content marketing, I'm looking for someone with a proven track record of success. - Database size: The B2B lead database is relatively small, with less than 1,000 contacts. This means that a tailored, individualized approach to each lead is possible, and I expect a high level of personalization in your conversion efforts. Ideal candidates should have: - A proven track record of success in converting B2B leads. - Experience with small lead...
...information all across various websites most of which I’ve never heard of or visited. Also there’s nonstop access to my existing online accounts and noticing 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...
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)∗...
I need a skilled Adobe Illustrator professional to convert a logo from PNG to SVG. The aim is to optimize the SVG for web use, ensuring it remains scalable, editable, and suitable for online platforms. Key requirements: - Conversion from PNG to SVG: The logo is currently in PNG format and I need it to be converted to SVG. - Scalability: The resulting SVG should be scalable to any size without losing quality. - Optimization for Web Use: It's vital that the SVG is optimized for web use. This includes ensuring the file size is minimized for fast loading times, and that it retains its quality across various screen sizes and resolutions. Ideal skills and experience for this job include: - Proficiency in Adobe Illustrator: Given t...
I'm looking for a graphic designer to create a vintage-themed cover for my music single. The theme of the design should be nostalgic and classic, with a touch of warmth and charm. Key Points: - The focus is on the vintage style, so experience in this area is crucial. - Warm color tones like browns, oranges, and yellows should be incorporated. - The design should be simplistic and elegant, avoiding any complexity. - Prior experience designing music covers is a huge plus. - A portfolio showcasing past vintage-themed works would be highly beneficial. I'm excited to see your creative take on this project! The winner will also do another variation of the winning graphic with logos of various musical platforms and just indicate that the music is ava...
I have a logo in a PDF format that I need converted to a vector format. In your application, please include your experience with similar projects. Please note, I do not require any specific color adjustments. Just a direct conversion from the PDF to a vector format.
I'm an artist seeking a skilled graphic designer for the creation of a single cover for my latest gospel music track. The cover should reflect the track's contemporary style and evoke a sense of serenity in its viewers. Key requirements for this project include: - Designing a music single cover in a contemporary style - Conveying a serene emotion through the design Given the nature of this project, I'm looking for a designer who can understand and translate emotions into visual elements, particularly in a contemporary design context. Strong communication skills are also crucial to ensure that the cover matches the mood and message of the track. Experience in the music industry would be a plus. I have attached a couple of photos. You may choose one of ...
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 stopped allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is availabl...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 th...
...graphic designer to help me create visual content for my business across various social media platforms. Key Requirements: - Experience with designing for Facebook, Instagram, Twitter, and LinkedIn - Proficiency in creating minimalistic graphics - Ability to work with specific colour schemes and branding guidelines Your role will involve: - Understanding the provided colour schemes and 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...
...offering fundraising services for charitable causes. Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs wi...
I need a skilled developer to take my Figma design and convert it into a responsive website using HTML5. The website should work flawlessly on all devices from desktops to smartphones. Additionally, I would like the website to include animations and interactive elements. Key Requirements: - Convert Figma design to HTML5 , CSS and JS - Ensure the website is fully responsive - Implement both animations and interactive elements Ideal Skills: - Proficiency in HTML5 , CSS and JS - Previous experience with responsive web design - Familiarity with animations and interactive elements Please include samples of your previous work and an estimated timeline for completion in your bid. Thank you!
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.
hello , i currently have my app in playstore up and running. but, i have created this ap...currently have my app in playstore up and running. but, i have created this app in drag and drop builder ( Kodular ). which have so much limitations as well, i am unable to push notifications for the new content. I am looking for someone who can convert or build same app with same interface and structure . What you have to do ? - Convert whole app from kodular to android studio. ( don't want any trace of the app ) - optimize app and UI for higher fill rate of ads. ( i am using FB ads to earn revenue ) - I will share API key once project done. - Allow me to easily update news or content from my PC ( Easy Backend ). - Add one more page to ...
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, maintainin...
...minor improvements to our UI. This project has a strict deadline, and must be completed within a single day. Your main responsibilities will be focused on form activation, including validation, submission, and integration. Dashboard view and Notification and reports. We need these actions to be seamless, reliable, and in accordance with industry standards. For the UI design, we're looking for someone with an eye for detail to refine the layout and color scheme. The improvements should be subtle yet effective, enhancing the overall user experience. Successful candidates should: - Have extensive experience working with LAMP stack, particularly in form development. - Be able to demonstrate previous relevant work experience. - Be available to...
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
