Excel find similar text in one columnงาน
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 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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
I am seeking an experienced SEO specialist to boost the online visibility of my brand within local search results. Here are my key requirements for this project: - Optimize my website specifically for my brand-related keywords, to ensure that our local customers find us easily when they look for our brand online. - The main goal is to get the visitors to contact us for more information about our offerings, once they land on our website from the search engines. Experience with local SEO, especially for brand-specific campaigns, will be highly regarded.
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
...innovative, custom design. Key Requirements: • Create a text-based logo with symbol elements. The design should be distinctive and contemporary. • Use a color scheme of blue and gold. Specifically, the design should feature blue letters with some elements in blue, while others should be in gold. My preference is for a vibrant, rich tone that ensures the design remains prominent and visually appealing. • Follow the examples provided in the attachments for the symbol elements to be incorporated into the design. The symbol chosen should reflect our brand and communicate our identity effectively. Ideal Skills: • Graphic Design • Brand Identity & Strategy • Visual Arts • Adobe Illustrator Please include your portfolio ...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. I'm hoping you can find impressive products that have potential to go viral. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Sharesale, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?
We have diagrams for the cars. We want someone who can create a database of where we can find the analog fuel sensor wire under the dashboard. Project is for 1000 cars and can be long term.
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing ...obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel...
...manage employee salaries, deductions, and tax withholdings. Integration or Custom Built: - I am not sure whether I prefer a custom built HRMS or integration with an existing platform. I am open to suggestions and recommendations from the freelancer based on their expertise and experience. Skills and Experience: - Experience in developing and implementing payroll systems for existing businesses. - Knowledge of HRMS best practices and compliance regulations. - Proficiency in relevant programming languages and frameworks for HRMS development. - Ability to provide recommendations and guidance on the best approach for the HRMS project....
i have a list of 11,000 car part numbers. need to find the image from each one, if you type the part number in google you'll find the image for that part.
...adults who are looking at showcasing their faith and evangelising. All designs are to be monochrome. Please find attached some examples of existing tshirts on the market that we would like to show as an example for ours. Please find below the 9 quotes to be designed on the tshirts: 1. "I can do all things through him who strengthens me." - Philippians 4:13 2. "Love one another as I have loved you." - John 13:34 3. "The Lord is my shepherd; there is nothing I shall want." - Psalm 23:1 4. "Be still and know that I am God." - Psalm 46:10 5. "I am the way, and the truth, and the life. " - John 14:6 6. "Rejoice in hope, be patient in suffering, persevere in prayer." - Romans 12:12 7. &q...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Pre...duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling nume...
I'm seeking a skilled and conscientious Android user who can help us identify bugs in our app's beta version. Key Responsibilities: - Daily testing: You'll be expected to provide daily feedback on any bugs you find. This will help us maintain a smooth and error-free user experience. - Detailed bug reporting: Clear, concise and detailed reporting on any bugs identified is crucial for our development team to address these issues quickly and efficiently. Ideal Candidate: - Experienced Android user: To be effective at this role, you should be very comfortable using Android phones. - Detail-oriented: You should be able to spot and describe even the smallest bugs. - Strong communication skills: Your feedback will be vital for our development, so the ability to art...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and effic...
I'm seeking a skilled and conscientious Android user who can help us identify bugs in our app's beta version. Key Responsibilities: - Daily testing: You'll be expected to provide daily feedback on any bugs you find. This will help us maintain a smooth and error-free user experience. - Detailed bug reporting: Clear, concise and detailed reporting on any bugs identified is crucial for our development team to address these issues quickly and efficiently. Ideal Candidate: - Experienced Android user: To be effective at this role, you should be very comfortable using Android phones. - Detail-oriented: You should be able to spot and describe even the smallest bugs. - Strong communication skills: Your feedback will be vital for our development, so the ability to art...
I'm seeking a skilled and conscientious Android user who can help us identify bugs in our app's beta version. Key Responsibilities: - Daily testing: You'll be expected to provide daily feedback on any bugs you find. This will help us maintain a smooth and error-free user experience. - Detailed bug reporting: Clear, concise and detailed reporting on any bugs identified is crucial for our development team to address these issues quickly and efficiently. Ideal Candidate: - Experienced Android user: To be effective at this role, you should be very comfortable using Android phones. - Detail-oriented: You should be able to spot and describe even the smallest bugs. - Strong communication skills: Your feedback will be vital for our development, so the ability to art...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I need a freelancer to replace the audio on one video, each approx 1.5 minutes in length. The replacement audio being provided will be in Mp4 format. Specific requirements are: Specific changes requested. - Familiarity with video editing software is essential - Should have experience working with Mp4 video and audio files - Demonstrable history of audio replacement or enhancement work in videos - Ideal candidates will be able to complete the task swiftly and flawlessly Note: The original purpose of the audio replacement (e.g., enhanced audio quality, new narration, removal of background noise) has not been specified. Therefore, the goal is merely to substitute the existing audio with the provided replacement.
As a property management business, we aim to attract new clientele through our new website. It should highlight the following services we offer: - Property Maintenance - Rental Management - Financial Management We specialize in residential properties, so the website should mainly cater to this market. The ideal freelancer for this job would have solid experience in web development and an understanding of real estate or property management. Not only do we need a visually compelling website but also functionality that effectively communicates our services to potential clients. Attention to detail, an eye for design, and understanding of SEO principles are also vital for this project.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I am seeking an experienced photo editor who can proficiently swap the photos so both dog a...photo editor who can proficiently swap the photos so both dog and person are looking at camera. - Task: Your main task will be to manipulate various images by swapping objects from one to another. - Software: As I did not specify any photo editing software, you have the flexibility to use the one you're most proficient in. It can be Adobe Photoshop, GIMP, Corel PaintShop Pro, or any other you find suitable for this project. - Timeline: I have not set a timeline for this project, therefore, quality is priority over speed. Ideal skills and experience: - Expertise in photo editing and manipulation - Proficiency in using photo editing software -...
I'm in need of a skilled Python coder to assist me in deploying Locally Hosted Language Model (LLM) applications. Here are the details: - **Operating System**: The deployment is hybrid, so familiarity with Windows, macOS, and Linux is ideal. - **Purpose**: The primary aim of the deployment is for text ebedding (vector db) and generation. - **Requirements**: Specifically, I'm looking for functionality related to Language modeling and retrieval augment generation in the LLM applications. - mongoDB should be set up runining a .sh file - docker-compose deploy of the app Essential skills for this project include a strong background in Python programming and experience with deploying applications on different operating systems. Previous work in...
Hi I am looking to hire a video creator for my ads. I will send you the product, you will find the videos on TikTok, ripped them and make 5 for each product. I can pay a monthly retainer and I will need you to make as much videos as I need to test. I won’t pay per video. I can pay a monthly salary. Let me know what would work for you. I will also send you a document explaining how to make my creatives. I am texting to different video editors and will pick the best offer. salary starting from $400 US Dollars/month and if you do a great job I will pay much more.
I'm in need of 4 consumers based in Karlsruhe, and visit 8 stores per city. Your task will be to gather data specifically on the promotional displays and materials used for a well-known dairy brand. Important: Candidate has to be based in Karlshue or very close to it. Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the p...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logisti...
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
French-speaking candidates only! My organization is currently leveraging several Zoho applications including CRM, Books, Inventory, People, Rec...synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zoho One and ERP integrations but also have a deep understanding of business processes, data management, and system admin work. Proficiency in managing user access and associated entity relationship is a plus. This endeavor aims to create a seamless workflow between Zoho and our ERP system, making data-driven strategic decision-making easier for us. The expert's ability to comprehend and execute these requirements will be crucial in en...
...LOGOS . final seleceted freelancer would need to work with us on finilizing it with our modification request and also would need to provide source font used. - The logo should have a modern and TECHY aesthetic, fitting the current trends in design. - It should incorporate elements related to lighting technology, but in a subtle and sophisticated way. - While this is important, the emphasis should not be solely on the technology. The design should be balanced, and the technology aspect should not overpower the overall look and feel of the logo. - If you can find a way to incorporate the idea of quick and safe installation into the design that fits naturally, that would be a huge plus. However, it is not a requirement, and the main goal is to create a visually appe...
I'm in need of a skilled and experienced freelancer to create a WordPress website for my jewelry brand. Key Requirements: - E-commerce Functionality: I want the website to have a smooth and secure checkout process, with the ability to add products, categorize them, and manage inventory. - Responsive Design: The website should be mobile-friendly, given that a significant portion of my target audience falls within the 25-45 years old age group, who are likely to access the site through their smartphones and tablets. Design and Layout: I don't have a specific design in mind, so I'm looking for a professional who can understand my brand and create a visually appealing, user-friendly website. Copywriting: Additionally, I'll need assistance with the copyw...
