Excel split comma separated values into rows formula jobs
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I have a PDF version of a brochure, and I require the double page spreads to be split into separate A4 pages. There are 8 double spreads to be split into separate A4 pages. The content should be kept exactly the same.
I need to scrape data from a website. I'm stuck with an error. I used improtxml to scrap...scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in and i...
App is done, just integrate webview at the checkout of the app. Urgent.
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
I require a talented freelancer to construct a text-based logo, along with an engaging introduction focused on emphasizing my company's mission and values. Additionally, I'm looking for the concept and design of formal business attire. Requirements: - Aesthetic and definitive text-based logo design. - Draft an introduction with captivation, mirroring our mission and values. - Original and professional designs for formal business attire. Ideal Skills: - Extensive experience with logo design and typography. - Excellent written communication for the introduction. - Creativity and expertise in formal attire design. - Understanding of the apparel industry's current trends. - Proactive, innovative and deadline-oriented. And providing the type of logo we nee...
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 compatibility issues - Strong un...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...
I'm looking for a professional to develop an informational website with a minimalistic corporate identity and logo. Key Requirements: - Design and build a clean, minimalistic, and user-friendly informational website. - Develop a corporate identity that reflects our brand's values and mission. - Design a minimalistic logo that aligns with the corporate identity. Website Features: - Contact form: A reliable and user-friendly contact form is crucial to facilitate communication with visitors. Skills & Experience: - Expertise in minimalist design, with a portfolio demonstrating similar projects. - Proven experience in website development, corporate identity, and logo design. - Strong understanding of user interface and usability principles. - Proficiency in design so...
...primarily focusing on enhancing brand recognition. You'll also be responsible for translating this logo into a series of engaging Instagram posts. Ideal Experience and Skills: - Proven graphic designing experience in the film industry - Proficient in design software and technologies - A keen eye for aesthetics and details - Exceptional creativity and innovation - Understands the impact of a strong brand and can embody our business persona into the logo - Experience in designing catchy Instagram posts Your contribution will play a crucial role in increasing our brand visibility and setting a creative tone for our organization. Your creative acumen can help us project our brand values and story to our esteemed audience. Instagram account : website : www
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout...
...extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...
...information memorandum. The aim of this presentation is to effectively represent: - Our company's business and main history milestone - Our mission and core values - Our company's business performance data - Our future business strategies A broad understanding of business analytics is essential as business performance data will be central to the presentation. Expertise in chart and graphics creations within Google Slides would be useful—it's important that the data is easy to digest and visually appealing. A creative outlook would also be beneficial to deliver our strategies in an engaging way and to help articulate our company values. Previous experience in business strategy presentations would be perfect. We will provide all the contents and the da...
I need a POC Flutter project that runs on iOS based on these 4 Flutter pub packages: 1. 2. 3. 4. And the functionality is very simple, so I basically just need the 1. Main templetate would be but with an additional screen using other 3 packages. 2. Create Okta native app on Application flow: 1. On Start app if not authenticated, show screen with Login button (middle of screen) 2. When Login button is clicked, goto Okta authenticate 3. If Authenticated : 3.1 Goto to new screen with big round button in the middle of the screen -> "SCAN" 3.2 When clicked, a BLE scan is started for 4 sec. 3.3 If one specific BLE device for the scan is found (based on ID), present faceID prompt and if succeded call a function with haptic feedback 3.4 then back to sc...
I'm seeking a skilled copywriter to help craft radio copy that will resonate with our audience and effectively communicate our brand traits of trustworthiness and quality. Your main tasks will be: - Understanding our brand: You should be able to capture the essence of our brand and the values we stand for. - Crafting compelling radio copy: You'll need to create engaging, impactful copy that conveys trustworthiness and quality in a way that captures and keeps the listener's attention. - Adaptability: The ability to create radio copy that aligns with our brand while also being flexible enough to resonate with different target markets is crucial. Ideal candidates will have experience in branding and copywriting, particularly in the radio medium. Understanding of to...
I'm seeking a skilled copywriter to help craft radio copy that will resonate with our audience and effectively communicate our brand traits of trustworthiness and quality. Your main tasks will be: - Understanding our brand: You should be able to capture the essence of our brand and the values we stand for. - Crafting compelling radio copy: You'll need to create engaging, impactful copy that conveys trustworthiness and quality in a way that captures and keeps the listener's attention. - Adaptability: The ability to create radio copy that aligns with our brand while also being flexible enough to resonate with different target markets is crucial. Ideal candidates will have experience in branding and copywriting, particularly in the radio medium. Understanding of to...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
I need a symbolic logo designed for my fitness brand, Alea Alea. This logo should evoke a sense of power and strength, reflecting the core values of my brand. The ideal freelancer for this project: - Has experience in professional logo designing specifically symbolic types. - Understands how to depict power and strength in design. - Can suggest innovative ideas keeping brand connotation in mind. - Has an impressive portfolio demonstrating their expertise and creativity. Looking forward to finding someone passionate who can bring my vision to life. Remember, this logo will be the face of the Alea Alea brand, it must be unique, impactful, and clear. The logo is going on Gym clothes so I want it to be clean and slick not bulky preferably in black or white but open to other colour...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...
...converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm in need of a professional who can help with data entry into spreadsheets. This is a straightforward task based on digital files I'll provide. Key Responsibilities: - Entering data accurately and efficiently into spreadsheets - Ensuring the correct format and organization of the data Ideal Skills and Experience: - Proficiency in data entry - Experience with spreadsheets - Strong attention to detail
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
I'm currently in the process of launching a new brand and consequently, in need of a sleek and professional logo that captures the essence of ERIA GK. The logo will primarily consist ...logo should effectively communicate a blend of qualities that are important to the brand - professionalism and sophistication, strength and reliability, and a touch of creativity and innovation. Ideal Skills and Experience: - Extensive experience in logo design, particularly creating minimalistic and impactful logos. - A good understanding of brand identity and how to effectively convey a brand's values through design. - Strong portfolio with examples of past logo designs that are both stylish and versatile. - Excellent communication skills to understand my vision and bring it to life thro...
... Here are the specifics: - Features: The bathroom should include a double vanity and a walk-in shower, but no Jacuzzi tub is needed. - Style: The overall design should be in a contemporary style. This includes a modern, minimalist approach, with sleek lines and a clean aesthetic. - Materials: The bathroom will feature quartz countertops. A minimum 60-inch vanity with a double sink A toilet separated from the rest of the suite by a wall and door. A tiled shower with subway tiles for both the walls and floor, possibly with a built-in bench. A walk-in closet/dressing room. Full-size 32-inch doors. If possible, the walk-in closet and dressing area should have direct access to both the bathroom area and the bedroom. We have a total area of 8 ft x 16 ft (128 sq ft) if you remove the ...
...dance academy. The goal of this website is to promote our classes and events, to showcase our performances and student achievements and to provide detailed information about the academy and its faculty. Key Features: - Home: The website should have a welcoming and informative homepage, providing an overview of our academy. - About Us: The 'About Us' section will include our mission statement, core values, and a brief history of the academy. - Classes: This page will contain information about the various dance classes we offer, the levels, timings, and any fees associated. - Events: A dedicated space to list upcoming events, workshops, and performances. - Gallery: A visual showcase of our past performances, student achievements, and the environment within the academy. -...
I'm in need of a professional logo for my news website. I'm seeking a logo that conveys professionalism. Clean, modern, and sleek design with a touch of uniqueness would be perfect. The logo will be the face of my bra...my news website. I'm seeking a logo that conveys professionalism. Clean, modern, and sleek design with a touch of uniqueness would be perfect. The logo will be the face of my brand, so it should be memorable and easily recognizable. Ideal skills and experience for this job include: - Proven track record in graphic design, particularly logo design - Ability to interpret brand identity and values into visual design - Strong understanding of color theory and typography - Creativity and originality in design approach Need 2 - 3 variation. So ...
...looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, fi...
I require a unique and professional logo for my company, AAJ Home Services. We majorly focus on home cleaning and remodeling services as well as commercial and industrial cleaning and want a logo that encapsulates our line of work and reflects our values. No strict deadline is set for this project, ensuring you plenty of time to create your best work. Skills and Experience: - Expertise in graphic design - Experience with creating logos - Strong creativity and artistic skills. Please submit your portfolios or samples of your previous work alongside your bid.
I'm looking for a creative, talented musician who can develop an upbeat, catchy pop jingle for our NDIS provider company. The jingle should embody the services we offer and highlight the values of our company. A strong grasp on pop music composition and prior experience in jingle composition would be ideal. Apart from music composition and lyrics writing, integration of the jingle into a radio format is important. Here's what I need: - Development of a catchy, upbeat pop jingle - Inclusion of our services and values in the lyrics - Conversion of jingle to acceptable radio format Please, only bid if you've got the skills and experience in the above.
...looking for a skilled female app developer to build a quick MVP and convert a physical card game into a mobile app game for both iOS and Android platforms. Quick note: I appreciate those who feel the need to start a chat and not so much those who have not bothered to read the brief before wanting to chat. I'll only start a chat if you have at least 2 to 4 links to card games you have published. Skills and experience required for this project: Experience converting physical card deck games into digital game experiences would be the ideal provider. The game brief overview: "Ello" is a two-player game played with a standard 52-card deck, where each player starts with 26 cards. The game assigns values to only four cards in the deck. In each turn,...
I have 11 simple digital imags that I need converted to an .STL file so I can have it 3D printed. The design contains basic geometric shapes and lacks complex curves or textures. Key Requirements: - Convert a simple digital image into an .STL file for 3D printing - Ensure the file is optimized for 3D printing to avoid any issues during the printing process. Ideal Skills and Experience: - Proficiency in CAD software - Experience in 3D modeling, particularly converting images into .STL files - Understanding of 3D printing requirements and how to optimize files for this purpose.
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX for the programm...
I'm in need of a talented graphic designer who can create a modern and minimalist logo for my brand "Valentius Kryptix". The primary use of this logo will be for brand recognition, hence it needs to be unique, memorable and easily identifiable. It should represent my brand and its values in a sleek and contemporary way. It MUST include/highlight the letters V & K. Key Requirements: - Modern and minimalist design style - Ability to craft a sleek and unique logo - Understanding of brand recognition principles - All file formats including CDR file The logo will be used across multiple channels like my website, social media, business cards, flyers and even merchandise such as apparel and mugs. Therefore, the design should be versatile and able to maintain its appeal...
...element you will need to identify and create/add the selector and existing colour These selectors must be defined with minimal specificity locate the necessary selectors for every single element and I estimate that this will be around 1,000 individual selectors/selector groups Everything will be thoroughly tested after completion so everything must work 100% correctly The file must be split into sections so it is easy to identify the colour settings for the header, footer and various page elements and also the different pages. You must add a comment describing each selector, e.g. // Announcement Bar .announcement-bar { background-color: #FFFFFF; } // Background .announcement-bar p { color: #000000; } // Text (the file will be in SCSS so the comments can be a...
I'm looking for a talented Website developer who can help me enhance my website and fix some SSL issues. Key Tasks: - Implement content updates to improve the overall user experience - Skillfully design and integrate new functionalities such as E-commerce and Social Media - Add details about the company including an about us page, a team page, and contact information - Create ...information - Create an enquiry form that will help in customer interaction - Resolve the SSL issue to ensure the website is secure for all users Skills Required: - Proficient in WordPress and cpanel - Experience in e-commerce integration - Strong understanding of SSL and security protocols - Creative web design skills - Strong communication skills to ensure the website reflects the company's v...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list of CRM numbers and a list of CID numbers. Process: Automate the lookup and data extraction process. Output: An Excel fil...
I'm looking for a talented designer to help me modernize my current bold and vibrant logo. Th...this project is to refresh and modernize the logo while retaining the original color scheme and symbol/icon. Key Requirements: - Modernize the existing logo to better reflect the brand's values and image. - Retain most of the original color scheme and symbol/icon. - Use a better font and text design for the brand - Keep the sun and use palm trees, Tampa florida skyline shadow (partial okay) , and the sun in the background or foreground Ideal Skills and Experience: - Previous experience in logo design, specifically with modernizing existing logos. - Strong understanding of color psychology and brand values. - Creative and innovative approach to logo design, while respec...
...looking for a developer to create a Chrome extension that will communicate with a server. The extension should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio...
...looking for a developer to create a Chrome extension that will communicate with a server. The extension should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of V...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
